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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
What is the "field size" for your field in the table? That controls how
large a number you can store.


Rick B
 
It sounds like the field size property in the table is set to "Integer". The
integer setting only stores whole numbers.
 
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

Access stripping decimal places in query 1
Decimal places in report 2
Formatting decimal places 8
Appending Rounds Decimal to Whole Number 9
decimal places 2
Stop Rounding in Forms 2
Conditional Decimal Places 7
Decimal places in charts 4

Back
Top