Remove currency symbols from columns in a combo box

[andrew]

How do I remove £ signs from a column in a combo box?

The field is set to currency data type in the table for mathematical accuracy. I can remove £ signs from text boxes forms and reports by changing the format, but this doesn't seem to work for columns within a combo box. Any ideas very gratefully received.

Thanks

Andrew

 

[Ken Snell]

Create a query based on the table. In place of the field that has the
currency setting, use a calculated field. Either of these should work:

Format([FieldName], "0")

or

Val([FieldName])


--

Ken Snell
<MS ACCESS MVP>

How do I remove £ signs from a column in a combo box?

The field is set to currency data type in the table for mathematical

accuracy. I can remove £ signs from text boxes forms and reports by
changing the format, but this doesn't seem to work for columns within a
combo box. Any ideas very gratefully received.