Decimal displays 1, 2, or None

  • Thread starter Thread starter LeLe
  • Start date Start date
L

LeLe

Most of the time I enter a whole number in the quantity field of my order
form; however, but once in a while I will enter a decimal such as .5 or .25

I don't want to change the formatting from 0 decimal places to 2. Is there
a way to format the control so the display will automatically change based on
the value entered by the user? In other words if the order is for 3 items
the form will display 3, and if the order is for .5 it will display .5 and
not round to 1 in the display. (Incidentally, the math works just fine, but
displaying the whole number will confuse the user.)

Thanks so much.
 
Did you try using a datatype of double, in the table and setting the decimal
places to Automatic?
 
Yes, I have tried that, and it seems to me that it should solve my problem,
but it didn't. Although I now also eliminated the format option of
"standard" which included a comma for numbers larger than 999 and
(unfortunately) required 2 decimal places be visible. ONce that was gone it
worked.

Thanks
 
Back
Top