How to: Format Output for Fields
You can specify the format used by values in fields from database tables when those values appear on forms, in browse windows, or reports. You can use format codes and characters to specify the format. For more information about format codes and characters, see Format Property.
To specify the format for field output
Open the database containing the table.
Open the table in the Table Designer.
On the Fields tab, select the field that you want.
In the Format box of the Display area, type the format characters that you want.
For more information, see Fields Tab, Table Designer.
To specify the format for field output programmatically
- Use the DBSETPROP( ) function to set the Format field property.
For more information, see DBSETPROP( ) Function.
For example, the following code specifies the output format for a postal code:
DBSETPROP("Orders.Postalcode","Field","Format","@R 99999-9999")