Percentage displays wrong

[Tomtheappraiser]

I have vreated a form where I would like to enter vacancy rate percentages. I
formatted the field for percentage, but whenever I enter a percent, for
instance I want to say 55%, it comes back 100%. I tried entering as .55,
..055, .0055, 55, 550, 5500. and I still can't get it to work.

Any help?

 

[Joan Wild]

The field is likely set to integer or long integer, neither of which can hold decimal values. Change the data type to single, double, or my choice would be currency. Formatted as percentage, you'd enter .55 and it would display 55%.

 

[Tomtheappraiser]

For the Format I already have it as "Percent". I can't find any "data Type"
in the property sheet. I looked under the data Tab and there wasn't a type
that could be changed. By the way I am using 2007. I don't know if that makes
a difference or not.

 

[Tomtheappraiser]

Nevermind. I had to go into the design mode of the database table in order to
set that. I got it fixed. Thanks for your help.