Numbers are automatically rounding off

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jtidwell - 17 Jul 2007 15:47 GMT

When I type in data in my form, the numbers are rounding off like 42.36 will
round off to 42... How do I change this

Reply to this Message

Douglas J. Steele - 17 Jul 2007 15:52 GMT

Check the data type of the bound field. If you select Number, the default is
Long Integer, which doesn't support decimals. You need to use a data type
that does support decimals, such as Single, Double or Decimal.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> When I type in data in my form, the numbers are rounding off like 42.36
> will round off to 42... How do I change this

Reply to this Message