Rounding of numbers in text box

  • Thread starter Thread starter Strugglin'
  • Start date Start date
S

Strugglin'

I made a form for data entry. The text box I am having
trouble with has a "Fixed Number" format, and 2 decimal
places. The problem is when I input a number in the form,
it is automatically rounded to the next whole number. The
rounded number is then carried over to my table, causing
inaccurate data to appear in reports.
I would like the number to appear as entered, limited to
two decimals. Any thoughts?

Please and thank you.
 
Is the table field to which your text box is bound an Integer or Long
Integer? If so, then these field sizes do not accept decimals; and you
would need to change the Field Size property of that field in your table to
Single, Double, Decimal or Currency.


hth,
 
It was Long Integer, I changed it to single...and now it
seems to work (still need to test output to reports).
Thanks a bunch
 
Back
Top