change $ to £ in time and billing database template

[shovelseller]

I downloaded from microsoft office online a template called time and billing
database for office 2003. I was able to install it in office 2000. To use the
invoice facility I need to change the $ sign to £ sign. How do I do this

 

[Klatuu]

If you have your regional settings properly configured, the currency symbol
should take care of itself.
In windows, go to Control Panel and select Regional Settings.
Exactly how you get there depends on your verson of windows.

 

[Jerry Whittle]

Most likely by changing the Regional Settings for the computer to
English(United Kingdom). If that doesn't work, you'll probably need to modify
reports to manually show the Pound sign. Something like below in the control
source. One problem is that you'll also need to rename the text box control
some as now you have a calculated control. For example the text box below was
named OWNER but I had to rename it txtOWNER to get the calculation below to
work.

="£" & [OWNER]

 

[Brendan Reynolds]

Assuming that your regional settings are correctly set for your local, don't
change them. That won't solve this problem. See the Microsoft Knowledge Base
article at the following URL, specifically the section labelled 'Currency
Format' ...

http://support.microsoft.com/kb/208596/en-us

To use the Currency format specified in your regional settings, instead of
those on the PC on which the template was created, you'll need to change the
Format property of all fields where the Data Type is Currency. For example
....

In the Database Window, select the Employees table, and open it in Design
View.

Select the field named BillingRate, which is the only field in this table
with the data type Currency.

Down near the lower left corner of the screen, find the Format property,
which has the value $#,##0.00;($#,##0.00). Change this to Currency.

When you press either the Enter or Tab key after changing the property to
Currency, you'll see a Smart Tag appear beside the Format field. (It looks
like an icon with a lightning bolt symbol). Click the icon to drop down a
list of options, and choose the option 'Update Format everywhere BillingRate
is used'.

A confirmation dialog box will be displayed showing the other objects where
BillingRate is used and asking you to confirm that you want to make the
changes. Choose Yes.

Repeat these steps for fields in other tables with the data type Currency.

If you want the data to automatically be displayed using the format
specified in the regional settings of the PC on which it runs, even if they
are different from the PC on which it was designed, you need to set the
Format property programmatically in the Open event of forms and reports. For
example, the following code, in the Open event of a form, would cause a text
box to adopt the format specified in the regional settings of any PC on
which it runs ...

Private Sub Form_Open(Cancel As Integer)
Me.txtTest.Format = "Currency"
End Sub