set a field to show decimal places on a form or report

G

Guest

I have tried several formats trying to get two decimal places to show on
forms and reports. ie: General Number, Fixed and Standard, with decimal
places set at 2 and auto. If I type in 5.25 it will only show as 5.00 - 5.75
will round up to 6.00. I need to have actuals in the database. What am I
doing wrong? Thanks
 
R

Rick B

What is the "field size" for your field in the table? That controls how
large a number you can store.


Rick B
 
G

Guest

It sounds like the field size property in the table is set to "Integer". The
integer setting only stores whole numbers.
 
R

Rick B

Why don't you try going to that field and clicking HELP? It will tell you
what all the entries mean.
 

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

Decimal places in report 2
decimal places in a form 1
Formatting decimal places 8
changing decimal places 2
format a number field to only show 2 decimal places if there are a 6
Trying to define # of decimal places for formatting a field on a f 1
Set a number field with decimal places. 3
list box will only show currency to two decimal places 5

Top