By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,454 Members | 3,103 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,454 IT Pros & Developers. It's quick & easy.

currency

P: n/a
Hi,
i have in my table/form two fields, first is number_field(decimal) 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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Why don't you use the AfterUpdate Event and use an If then Else Statement.

Air Code:

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

HTH

Michael
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.