I have an Access 2010 database obtained from elsewhere. One of the summation fields on a report shows as $xxxx. I want to change it to £xxxx.
In the Properties for the field the Format is $#,##0.00;($#,##0.00) .
If I try to change the two $ to £ it rejects it saying The text you entered isn't an item in the list. Indeed it comes up with this even trying to change it what it currently says. This clearly happens because there's a drop down which is limiting the input values.
So firstly how did this value get there in the first place?
And how can I change it to show £ ? Changing format to Currency results is slightly different alignment, and anyway I want to understand rather than just get round it.
Edit to correct title
Edited by cheshire_man (Thu 23-Aug-12 18:18:24)