How to store numeric data in currency format other than $

  • Thread starter Thread starter Paul Mak
  • Start date Start date
P

Paul Mak

I have a numeric data field for the UK currency ie £.

How to store this numeric data in Access database with the currency sign
"£"? Thanks.
 
I have a numeric data field for the UK currency ie £.

How to store this numeric data in Access database with the currency sign
"£"? Thanks.
Click to expand...

Use the Windows Start... Control Panel... Regional option to change
the default currency character.

The dollar sign (or the pound sterling, or the yen, or the Euro) is
not stored in the field; the table actually contains a binary
representationof the numeric value with no text.

John W. Vinson[MVP]
 
Back
Top