decimal nmbers denied

  • Thread starter Thread starter emiyn
  • Start date Start date
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.
 
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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top