Need to force two decimal places in an Access 97 report

M

Megan

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!
 
J

James A. Fortune

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
 
Top