A2007 Losing decimal places

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

I have a continuous form with a simple bound text box. It's bound to a column
that's defined as "decimal" data with 1 decimal place. The text box is
formatted with one decimal place. When I enter 3.5, the box corrects it to
"3". The table view does the same thing. It's not the form. So, where did I
go wrong? I've never used "decimal" data type before.
 
Figured it out. Not only do you have to set max decimal places,but also set
the "scale" to one decimal place.
Thanks
 
Back
Top