Decimals

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

Guest

I'm fairly new at this and I may be missing something very simple, but when I type a decimal in a table, or form the decimal portion doesn't show. I have set the "Data type" to Number, the "Field Size" to Decimal, "Format" to standard and "Decimal places" to Auto, but still when I type 8.5 it displays as 8.00

What have I missed?
 
Dawn said:
I'm fairly new at this and I may be missing something very simple,
but when I type a decimal in a table, or form the decimal portion
doesn't show. I have set the "Data type" to Number, the "Field Size"
to Decimal, "Format" to standard and "Decimal places" to Auto, but
still when I type 8.5 it displays as 8.00

What have I missed?
Click to expand...

Maybe this will help from the MS Access Help file:
Use a Number field to store numeric data to be used for mathematical
calculations, except calculations that involve money or that require a high
degree of accuracy. The kind and size of numeric values that can be stored
in a Number field is controlled by setting the FieldSize property. For
example, the Byte field size will only store whole numbers (no decimal
values) from 0 to 255 and occupies 1 byte of disk space.
 
For the Decimal field type, you also need to set the 'Scale' property for
the number of decimal places you want. This property controls the number of
decimal places actually stored, while the 'Decimal Places' property controls
only the number of decimal places that are displayed.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


Dawn said:
I'm fairly new at this and I may be missing something very simple, but
Click to expand...
when I type a decimal in a table, or form the decimal portion doesn't show.
I have set the "Data type" to Number, the "Field Size" to Decimal, "Format"
to standard and "Decimal places" to Auto, but still when I type 8.5 it
displays as 8.00
 
Back
Top