change curreny from euro to pound

[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

 

[John Nurick]

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)