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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unwanted Numbers Rounding 6
rounding problems 11
Text boxes rounding entries 3
Form: remove number rounding 1
How do I stop rounding of my calculation results. 6
Don't want Access to round numbers to nearest integer. 1
Form Rounds up Decimal numbers, WHY? 7
Round() Function 2

Back
Top