If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Currency" format lost in subform.
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 |
#2
|
|||
|
|||
"Currency" format lost in subform.
You should be able to go to the design view of the subform and change the
properties of the subform fields. "Frank Martin" wrote: 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 |
#3
|
|||
|
|||
"Currency" format lost in subform.
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" wrote in 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 |
#4
|
|||
|
|||
"Currency" format lost in subform.
For some reason this does not work. Thanks
"John Spencer" wrote in 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 . "Frank Martin" wrote in 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 |
#5
|
|||
|
|||
"Currency" format lost in subform.
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" wrote in message ... For some reason this does not work. Thanks "John Spencer" wrote in 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 . "Frank Martin" wrote in 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 |
Thread Tools | |
Display Modes | |
|
|