# is rounding. Do not want

  • Thread starter Thread starter cedia
  • Start date Start date
C

cedia

I need help. I have a field set as number. long integer
size, standard format with 2 decimals. the number keeps
rounding if i enter in a decimal number in the forms and
thru datasheet view of table. can someone help me?

thanks!
 
The Integer types (including Long) can store only whole numbers.

In table design view, change it to a Number of size Double instead.
 
You need to change the Data Type (Field Size) from Integer to Single or
Double, also change the Format and Input Mask if you have them. Since you
have already created the form, the setting changes won't be carried over
automatically. You'll need to go to the textbox on the form and set Format
and Input mask there as well.
 

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

Pivot table view does not show series data with decimals? 0
Access stripping decimal places in query 1
Unwanted Numbers Rounding 6
Decimal places in forms 2
rounding problems 11
Don't want Access to round numbers to nearest integer. 1
How do I stop rounding of my calculation results. 6
Percent value rounds up in Access 1

Back
Top