currency

[J.J.]

Hi,
i have in my table/form two fields, first is number_field(de cimal) and
second is combo with two values from other table(USD and EURO). now i want
that after i select USD the number_field is formated as Currency and if i
select EURO than as Euro.
how can i make this happen?
many thanks
J.J.

[Lumpierbritches]

Re: currency

Why don't you use the AfterUpdate Event and use an If then Else Statement.

Air Code:

If cboCombobox.val ue = USD Then
textbox = Format(value, "currency")
Else If cboCombobox.val ue = Euro Then
textbox= Format(Euro Format)
End If

HTH

Michael