Work around to make dec field accept dec values?

[Jay]

I created a table with Number[Decimal] fields but. even in Table view,
attempted decimal entries are converted to integer and I need the full
decimal. Is there a work-around?

 

[Dirk Goldgar]

I created a table with Number[Decimal] fields but. even in Table view,
attempted decimal entries are converted to integer and I need the full
decimal. Is there a work-around?

What did you specify, in the table design, for the Decimal Places property?
I have a decimal field in a table, and it accepts decimal places just fine.

 

[Larry Linson]

I created a table with Number[Decimal] fields but.
even in Table view, attempted decimal entries are
converted to integer and I need the full
decimal. Is there a work-around?

I Googled on "decimal field" and "Microsoft Access" the first item returned
was http://allenbrowne.com/bug-08.html and the third was
http://www.fmsinc.com/FRee/NewTips/Access/accesstip46.asp. To my personal
knowledge, these are "authoritative sources" and the advice in both that I'd
heed is "avoid using decimal fields".

While they do not deal with the problem you describe, I think you'll find
that problem does not occur with other types of numeric fields that allow
decimal places: single, double, currency. Of course, by definition, neither
integer nor long integer allows decimal places in the stored data.

Larry Linson
Microsoft Office Access MVP