Format a multiple column combo box

  • Thread starter Thread starter Dorian
  • Start date Start date
D

Dorian

How do I apply a Format to a single column of a multiple column combo box? I
have 2 columns, the first is text and the second is a currency amount. I want
to prefix thesecond column with '$'.
Thanks
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
format it in the combo's row source query:

SELECT SomeField, Format(MoneyField, "Currency") From SomeTable;
 
Back
Top