change curreny from euro to pound

  • Thread starter Thread starter baz
  • Start date Start date
B

baz

Hi

I have selected currency as data type but on my table it
shows the euro symbol and I want the £ symbol. It is
Access 97.

help!

Thanks
 
Hi baz,

WHen you use the Currency data type, the default formatting for
datasheets and controls is normally taken from the Windows regional
settings. Does your computer think it's in the sterling area or the euro
zone?

To fix this without altering the Windows settings, you can just set the
Format property of the field(s) and control(s) to something like

£#,##0.00;(£#,##0.00)
 
Back
Top