Combo Box font color

[JK]

Hi to all,

I have a problem changing font colour in a combo box when Column 1 in the
box
is not the first field in the query on which the box is bases on.

Example:
Table: Currencies

Fields:
Currency_ID (Auto-Key)
Currency (text - eg "Australian Dollar")
ISO Code (Text - eg "AUD")
etc

Query: q Currencies List
SELECT Currencies.Currency, Currencies.[ISO Code], Currencies.Currency_ID
FROM Currencies ORDER BY Currencies.Currency;

Combo 1 RowSource (working OK)
SELECT DISTINCT [q Currencies List].Currency, [q Currencies
List].Currency_ID FROM [q Currencies List] ORDER BY Currencies.Currency

The problem is:
Combo 2 RowSource (Cannot change colour)
SELECT DISTINCT [q Currencies List].[ISO Code], [q Currencies
List].Currency,[q Currencies List].Currency_ID FROM [q Currencies List]
ORDER BY Currencies.[ISO Code]

..ForeColor is ignored when the box is closed, although working OK when the
drop down is open, the same is true when the colour is set in design view.

Any solution?

Regards/JK