Percentage Text Data Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field in a table, I tried setting it to Number and format as
Percentage. Set decimal places to 2 and when I enter 2.19%, it changes to
2.00%. Any idea why? I changed decimal places back to Auto, still does it.

Right now it is a text field with the numbers inputed as a text number, like
2.19, etc. But when I tried an update query, like add 0.02% but used 0.02,
it would turn it into 2.1902. I'm not sure what to do exactly?

Thanks
Curtis
 
the default FieldSize property for Number data type is Long Integer (unless
you change that setting in Access). Long Integer holds whole numbers only.
to store fractions of numbers, set the FieldSize property to Single or
Double or Currency, in table design view. you can read up on the field data
types in Access Help, and decide which field size is best for your needs.

hth
 
I thought I played around with that, but I guess I didn't pick the right one!
THANKS!

Btw, what about input mask? Like I have 00000;;_ for Zip code field so it
auto tabs, but what do you use for numbers with a decimal, like 1.59%, it
wont reconize the . as a character.

Curtis
 
well, i don't know that i'd use an input mask for numeric values - actually,
i'm not sure if an input mask will work in a control bound to a Number data
type field. if you have finite minimum/maximum values, suggest you set a
validation rule to confine the data entry to those limits.

hth
 
Back
Top