Crystal Display Conundrum

need help on reports showing incorrect currency symbol

on my workstation the reports all display correctly with the correct currency symbol. This is the GBP sign () which is formatted into each currency field on the report.

on another machine, I get the US dollar sign ($). Both machines are set to the regional settings of UK, both use the English/British keyboard, both have the currency symbol in windows set to and both machines display the in all other applications (ms access and ms excel etc)

the data is pulled from access into a vb app and from there a crystal report is launched. the data is correct in the ms access database and also in the forms in the vb app.

i've even checked out the printer settings and there was nothing there to enable you to change the currency symbol, but this printer is shared between two machines and it is correct on the other machine.

why-oh-why does it display $ instead of on the report itself :confused:

WoodyHi,
You have specified that the data are taken from Access to VB. What is the data type of the fileld?. If it is Currency then Access will use the Symbol $ default. Thats why $ is printing in the report. Try to change that filed type as Number if it is Currency data type.

Madhivanan|||managed to get this fixed.

this system has been in place since 1998 and has worked perfectly until the user bought a new pc. the data is stored in the access database as currency and then both the vb app and the crystal reports have formatting to use the pound sign when displaying the figures.

this has worked for 6 years and the application is robust - even coping well with the millennium bug.

and when i say the user bought a new pc, I mean new to her - it has win 98 on it like the original one did.

i installed the crystal report engine on her machine and found that it was formatting the fields to use a dollar. i copied the report files from my machine where they have a pound sign. during the installation of the app (using the vb package wizard) I included the reports and it used the dll that I use on my machine and they all use the pound sign.

so basically something along the way somewhere told crystal to overwrite the formatting i set and use the dollar instead. don't know what, and bloody annoying, but all sorted now.