Percent Field

[Parra]

I want to have a percent field for a table but for some reason it is not working properly. I have the field linked to a form and all I want it to be able to enter .25 to produce 25% or 1 to produce 100%. What am I doing wrong. When I enter numbers it does not allow me to enter the decimal.

Parra

 

[Dugantrain]

Are you saying that you want the Values to be Stored in the underlying tables as a Percentage? I don't believe this is possible using standard numbers but, then again, why would you want to? You should be storing the numbers as numbers and using the Format option in Tables, Forms, and Queries to display them as a Percent.

 

[Parra]

I have the following properties for the field:

Data Type: Number
Field Size: Long Integer
Format: Percent

I just want to be able to enter .25 and get 25%, what could I be doing wrong?

 

[Dugantrain]

Oh wait, ok, I know what's going on. Long Integer doesn't allow for decimals, only Integers. Change your Field Size to Single.

 

[Parra]

That did the trick, thanks.

This database is coming around slowly. Now if I can only come up with a name for it.

Parra