Currency format doesn't 'take' in Queries and Reports

A

alan

I have set the format properties for some fields in a form and report as
'currency'.

However some of these fields continue to display as ordinary numbers (ie.
1234 instead of $1,234.00) notwithstanding that the property of those fields
have been changed.

How can I 'force' the forms and reports to display these fields in currency
format? These fields are based on simple formula in a query.

(using Access 2000 & W2k. All service packs installed).

Thanks in advance.
 
R

Rick Brandt

alan said:
I have set the format properties for some fields in a form and report as
'currency'.

However some of these fields continue to display as ordinary numbers (ie.
1234 instead of $1,234.00) notwithstanding that the property of those fields
have been changed.

How can I 'force' the forms and reports to display these fields in currency
format? These fields are based on simple formula in a query.

(using Access 2000 & W2k. All service packs installed).
Click to expand...

Display properties generally don't propagate to other objects that use the base
object. Form and Report controls will inherit properties from Table fields IF
they are created after those properties were assigned in the tables. Otherwise
you have to duplicate the property settings in the new objects.

You definitely lose display inherited properties as soon as you put the field
into an expression.
 
K

Ken Snell

Use a calculated field in the query in place of the field:
FieldCurr: CCur([FieldName])
 
V

Van T. Dinh

Not sure from your description as I think you used "Field"
in places but you actually meant Controls. Reports/Forms
don't have "fields". They have Controls which are
the "visible" elements you see. Reports/Forms general
have RecordSources and the RecordSources have Fields that
bind the Controls.

I am guessing that you already set the Format Property of
the Controls to "Currency". In this case, try wrapping
your simple formula (in the Query) with the function CCur
() which converts the value to Currency type.

Also, checking the Currency settings in your Regional
Settings of your OS.

HTH
Van T. Dinh
MVP (Access)
 
A

alan

Thanks All. It works.

Just getting started with Access and find this confusing - much appreciated!
 
Top