Hi Rick,
To start with, it sounds like you should change the field
from Long Integer to Currency (data type - different than
format) or Single or Double (field sizes of the number
data type), since Long Integer cannot store decimal
fractions of numbers. I am assuming that you want to be
able to do this since your example used 6.5. I often use
the currency data type for percentage fields because
currency is fixed to 4 decimal places which, when
combined with the percentage format, actually displays
percentages to two decimal places. Single and Double
field sizes of the number data type are floating point
numbers, so you may encounter some rounding of numbers
depending on what you are entering, but they can handle a
much wider range of values.
As you noticed, the default percentage number format
automatically multiplies the actual entry by 100 when
displaying it. In numeric terms this is correct because
50% is in fact 0.5, but if you prefer to store 50% as 50,
you would have to create your own custom format to just
add the % sign to whatever value is in the field.
HTH
-Ted Allen
-----Original Message-----
I have a field called TAX. For the field size I have
Long Integer and for the Format I have Percent.
I have tried different ways but I cannot get the right
formula whereby when the user types 6.5 the result will
be 6.5%. I keep getting 650.00%.
