Showing Value on Form as Percentage

[mvpdep]

Hi all I know this is probably an easy thing. I have a table with a field called 'tbl rate'. I have set it to Number. Within this field the properties are as follows:

Field Size: Long Integer
Format: Percentage
Decimal Place: 2

I would like to enter 1.7 and have 1.7% show in the field. However when I enter 1.7 my field displays 170%. How do I change the formatting so that I can view the actual percentage.

Please help thanks. A simple fix I'm sure.

 

[HandsOnAccess]

Are you entering data in the the table directly?
There is not much we can do while entering data directly into table.

For Field Size = Long Integer, You can never have Decimal Place = 2. Even if you put it as 2, the number will get rounded off.

For Decial Place to work properly you need to use Field Size = Double.

Entering .017 should give you 1.7

Regards,

 

[mvpdep]

Thank you