Re: How to store numeric data in currency format other than $

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Tue, 17 May 2005 09:25:13 -0700, "Paul Mak" <paul_mak@xxxxxxxxxxx>
wrote:

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

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

Relevant Pages

  • How to store numeric data in currency format other than $
    ... How to store this numeric data in Access database with the currency sign ...
    (microsoft.public.access.forms)
  • SUM (?) in Report
    ... Textbox1 to display VolPurge1; ... Textbox9 to display VolPurge9 (Numeric data field too). ... When there are numeric data in all fields, the SUM work ...
    (microsoft.public.access.reports)
  • inserting null into DB
    ... I am encountering a problem as follows: ... its stored into the dbase as numeric data field ...
    (microsoft.public.inetserver.asp.db)