If your keyboard does not have the British pound symbol, you can generate it
by holding down the Alt key and typing 0163 on the numeric keypad.
You may also need to be aware that although Access *displays* the word
"Currency" in the Format property of the fields in your table and controls
on your forms, it actually stores the currency settings of the developer. If
the database is moved into a different locale, the word "Currency" suddenly
disappears, and the Format property appears as if it were hard-coded to the
developer's settings, i.e. it does not adapt to the user's Control Panel
settings.
This means that you need to programmatically set the Format property for
every affected control in the Open event of every form and report. You may
therefore want to store the entire format string in your lookup table, since
you will need to retrieve it and reassign it many times in every user
session.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
Brian McGuigan said:
I want to extend my database to handle multiple currencies. I wish to
create a Table 'Currencies' that would hold, amongst other things, a
'Currency Symbol' which can be used as part of the Format String when I wish
to display currency amounts in that currency. I am aware Access has special
provisions to handle the Euro, but how do I go about handling the British
Pound Symbol for example?
