Numbers in Access form

G

Guest

How do I stop ordinary numbers from being rounded up on an MS Access form. I
want the numbers to be displayed to two decimal places. I have already
formattted the field as general number to 2 decimal places.
 
R

Rick Brandt

Will said:
How do I stop ordinary numbers from being rounded up on an MS Access
form. I want the numbers to be displayed to two decimal places. I
have already formattted the field as general number to 2 decimal
places.
Click to expand...

You probably chose a "size" in the table of Integer or LongInteger for that
field. These don't support decimal places. Change to Single, Double, or change
the type to Currency.
 

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
Access stripping decimal places in query 1
Pivot table view does not show series data with decimals? 0
Decimal places in forms 2
How do I stop rounding of my calculation results. 6
Excel Stop Excel from displaying rounded values 4
rounding problems 11
Why wont my control accept decimal places? 2

Top