Formatting in Number Field (1 Viewer)

[heiligm]

I have a field in my form that I want to be a %. I want to enter the number and have it display at that %. For example, I may enter "78.86" and after I tab out, I want to see it as 78.86%. I have the text box set to Number and formated for Percent but when I enter a number, almost any number, I'm only getting 100%. In fact, it its less than 50% it shows as 0. When I enter that "78.86" example, it returns "100%". This has to be so simple but I don't know what I'm going wrong.

 

[CraigDolphin]

Make sure the numeric fieldsize property of the field in the table is set to either single, double, or decimal, not integer or long.

 

[heiligm]

Thanks Craig. That fixed the 100% problem but now it's rounding. I need exact values, (ie 98.87%).

 

[CraigDolphin]

Set the format property of the field to fixed, and specify the number of decimal places you want in the Decimal Places property of the field.