How to store numeric data in currency format other than $

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.
 
J

John Vinson

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

News Bank of England considers digital currency 4
custom currency symbol independent of regional settings 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access Form Refresh 1
Currency designations 2
Numeric AND Text 4
Converting currency value to text value for bank checks. 17
Help with an expression to calculate a profit from one of three fi 2

Top