Need help putting 2 decimal places in a report

[Guest]

I am very much a novice at Access. Please give detailed explanations. )

I am trying to create a report with currency ($x.xx). I have tried every
properties I can find and put in format ($#.00), and decimal places (auto).
It is not working!!!!!!! Please help!!!!!!!!

 

[Guest]

In the field Property select
Format Property = Currency
DecimalPlaces Property = 2

 

[Guest]

Sorry but that didn't help.

In the field Property select
Format Property = Currency
DecimalPlaces Property = 2
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

 

[Guest]

Whet do you get?
What is the field type?
If it's string then try this
=Format(CDbl([FieldName]),"#.00")
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

 

[Mike Revis]

Presumably when you set up the table you set the data type of the field to
currency.

Table design view. Field Name. Data Type = Currency.

Presumably when you placed the field on the form you set the format to
currency.

Form design view. Field property sheet. Format tab. Format = Currency.

When you place the field on the report in the field property sheet. Format
tab. Format = Currency.

This "should" display the field on the report in the Currency format for
whatever your regional settings are.

hth Mike