How do I get two decimal places in a labels report in Access 97?

[Guest]

I have tried the format section in the table section and set it to currency
as well as $#.##. When I try to print labels with it, if the last decimal
place is a 0 (zero), it won't print it. Thanks in advance for help.

 

[Joseph Meehan]

I have tried the format section in the table section and set it to
currency as well as $#.##. When I try to print labels with it, if
the last decimal place is a 0 (zero), it won't print it. Thanks in
advance for help.

You also may need to format the field in the report.

 

[Guest]

Okay... how do I do that? I am very much a novice with Access. I went to
design, clicked the area that should be amount, found properties and changed
the format to currency - nothing changed. I also did $#.## and still nothing
changed. Am I doing something wrong? Thank you!!!

:

 

[Douglas J. Steele]

$#.00

 

[fredg]

Okay... how do I do that? I am very much a novice with Access. I went to
design, clicked the area that should be amount, found properties and changed
the format to currency - nothing changed. I also did $#.## and still nothing
changed. Am I doing something wrong? Thank you!!!

$#.## is not what you want.
$#.00 (or $#,###.00) is.

The .00 forces the 2 decimals.

 

[Guest]

Thank you! Thank you! Thank you! I gave up on this months ago and thought I
would give it another try tonight. Again, thank you!