Remove currency symbols from columns in a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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>

andrew said:
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
Click to expand...
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.
 
Back
Top