Good day.
firstly let me say thanks for the help.
here is what i have a problem with:
i have a Split Form that lists projects projects are world wide and there for many different currencies have to be listed on the Split Form.
now i know that access defaults to the currency that your local PC is set to, but i have been able to get around that by using custom formatting:
i created a table with all the currencies and there symbols that will be needed.
then i used the following code for my formatting:
Dim Symbol As String
Private Sub Report_Load()
Symbol = (Me.CurrencySymbol)
Price.Format = Symbol & “” & (“##,##0.00”)
Price.Format = Symbol & “” & (“##,##0.00”)
Out.Format = Symbol & “” & (“##,##0.00”)
Paid.Format = Symbol & “” & (“##,##0.00”)
TPrice.Format = Symbol & “” & (“##,##0.00”)
AccessTotalsChargedAmount.Format = Symbol & “” & (“##,##0.00”)
this works with out a problem ^_^ as long as there is only one currency on the form …
how do i adjust mt code so that it will apply the formatting to each project that i am listing on my Split Form ?
at the moment it checks what the currency symbol is of the first project and applies that to all projects so i ens up with UK project with $ amounts.
Cheers
Franscois