"Currency" format lost in subform.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have a subform that has a combo which
selects filtered records.

The combo has a field "ItemPrice" which has
lost the currency format, but this format is
OK when the underlying query is activated
separately.

It wont work when it is a subform it seems.

Nor will it work when in a ListBox.

How can I fix this?

Please help, Frank
 
You should be able to go to the design view of the subform and change the
properties of the subform fields.
 
As far as I can recall, you would need to use the format function to force
the format in the underlying query for the combobox or the list box.

Field: MyCurrency: FORMAT([TheCurrencyField],"Currency")

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
For some reason this does not work. Thanks


message
As far as I can recall, you would need to
use the format function to force the format
in the underlying query for the combobox or
the list box.

Field: MyCurrency:
FORMAT([TheCurrencyField],"Currency")

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and
Management
University of Maryland Baltimore County
.

message
I have a subform that has a combo which
selects filtered records.

The combo has a field "ItemPrice" which
has lost the currency format, but this
format is OK when the underlying query is
activated separately.

It wont work when it is a subform it
seems.

Nor will it work when in a ListBox.

How can I fix this?

Please help, Frank
Click to expand...
Click to expand...
 
Are you using that expression in the query as a calculated column? It
should work- it has always worked for me.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Frank Martin said:
For some reason this does not work. Thanks


John Spencer said:
As far as I can recall, you would need to use the format function to
force the format in the underlying query for the combobox or the list
box.

Field: MyCurrency: FORMAT([TheCurrencyField],"Currency")

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
.

Frank Martin said:
I have a subform that has a combo which selects filtered records.

The combo has a field "ItemPrice" which has lost the currency format,
but this format is OK when the underlying query is activated separately.

It wont work when it is a subform it seems.

Nor will it work when in a ListBox.

How can I fix this?

Please help, Frank
Click to expand...
Click to expand...
Click to expand...
 
Back
Top