Format a multiple column combo box

[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".

 

[Klatuu]

format it in the combo's row source query:

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