decimal nmbers denied

E

emiyn

I have a certain problem with Access2000.
In some textboxes I am only able to write integer number, so I cannot write
for example 1.5 and it only accepts 2.
What should I do to solve this problem?
Thank you.
 
D

Dirk Goldgar

emiyn said:
I have a certain problem with Access2000.
In some textboxes I am only able to write integer number, so I cannot
write for example 1.5 and it only accepts 2.
What should I do to solve this problem?
Thank you.
Click to expand...

Probably the text boxes in question are bound to fields whose Field Size
(in table design view) is Long Integer, Integer, or (maybe) Byte. These
are all whole-number data types, so they can't hold fractional values.
If you want to be able to store fractional values, use Single or Double
for the Field Size property, or else use the Currency data type.
 
Top