Hi,

I have a text box on my form, txtDiscount. Its format property has been set to:
"RM "#,##0.00;[Red]"RM "#,##0.00;"RM 0.00";"RM 0.00"
(RM is Malaysian currencty).
Now I have added a combo box cboCurrency, its rowsource is a table with various types of currency. How do I update the text box format according to the selected currency in the combo box? How do I write a function to return the currency ID bound column of the combo box and concatenate it to form the format string?

Scott