Need help putting 2 decimal places in a report

M

Megan

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

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

Megan

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...
 
O

Ofer

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
 
M

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
 
Top