Let user choose currency

[huzefahashim]

Hi,
My company exports to different countries. So when the orders come,
the order currency can be US $, Pounds or Euros.
How can I set it that the user is able to select what currency the
order is in?
Thanks,
Zef.

 

[Allen Browne]

If you accept the order in any currency, and your company wears whatever
price fluctuations there are between the time when the order is placed and
the time when the order is shipped, you could just add an extra field to
your table to store the currency.

The field would be a combo box, that looks up a table of valid currencies.

Then set the Format property of the text box where the currency amount is
entered to:
Standard
so no currency symbol appears in that box.