Field formats on form

AndeanWayne

Registered User.
Local time
Today, 10:21
Joined
Jan 21, 2012
Messages
27
I have a form that has fields (text boxes) selected form a combo box. One field is currency format an the other is percentage format. The source for the combo box is a table and both fields are formatted properly and display properly as currency and percentage in the table. In the form I have selected the appropriate formats but the data displays as just a number ( ie the percenage just displays as .03 rather than 3%). How can I get the form to display properly? Is my problem that these fields are unbound field based on the combo box?
 
Open the form in design view. Right click on the form. Click on Properties. Select the control (text box) you wish to format and click on the format tab and then select the format you wish from the drop down selection.
 
I did this. The text boxes are formatted as currency and percent respectively but persist in displaying as a nuumber with two decimal places.
 

Users who are viewing this thread

Back
Top Bottom