Need help putting 2 decimal places in a report

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

Guest

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

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!!!!!!!!
 
Sorry but that didn't help.

Ofer said:
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
Click to expand...
 
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
 
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
 
Back
Top