Need to force two decimal places in an Access 97 report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have done what I thought I did last time but it is not working. I have
gone to the report design view, clicked on properties and changed format to
$#.00 but I'm not getting two decimal places. I have changed the format in
all areas of the database but still nothing. Please help!
 
Check that the DecimalPlaces Property of the field set to Auto or 2, and not
to 0
 
Megan said:
Yes, I have them set to 2.

:
Click to expand...

My guess is that you have a text field with numbers in it. In the SQL
for the report's RecordSource add another variable like:

Val(Nz(MyTextField)) AS MyAmount

Set the ControlSource of the text box on the report to MyAmount instead
of MyTextField.

Then Format = Fixed and DecimalPlaces = 2 will give you two decimal
places. If that works, try Format = $#.00.

If you have control over the table design and the field is a text field,
change it to something like Double after making a backup of the table.
Then an Nz will be enough.

James A. Fortune
 
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

Access stripping decimal places in query 1
Formatting decimal places 8
Conditional Decimal Places 7
Decimal places in charts 4
Decimal places in report 2
decimal places 1
Multiple Decimal Place Formats on Report 6
Decimal Places 1

Back
Top