"Currency" format lost in subform.

[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

 

[akphidelt]

You should be able to go to the design view of the subform and change the
properties of the subform fields.

 

[John Spencer]

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]

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