missing $ currency type

[qwertyjjj]

I have a form and have tried to list the currency types in it but it doesn't display the $ sign, hence anything with dollars, I have to put in a general number.
ANy ideas on how to get it listed in Access or VB ?

 

[Rabbie]

Go to the properties page for the boxes where you display the currency and change the format to Currency. You may need to scroll down past General number to see this option. This should do the trick for you

 

[missinglinq]

"I have a form and have tried to list the currency types in it"

Not sure exactly what you mean by the above statement, but if your field is defined as Currency datatype in your table and the default currency for the Regional Settings as set up in Windows is the dollar, it should show up with the dollar sign.

 

[qwertyjjj]

Sorry, that is what I mean. When I go to Properties and select currency, there is no dollar sign in there. Only £ and Euros
The Currency default is £
There is a separate entry under it called Euro with the Euro sign.
No dollars though ?

 

[Rabbie]

Have you checked your regional settings in Control Panel. This sets the currency character for whichever country you choose. Which country are you based in.

 

[qwertyjjj]

The currency is the correct one, it displays £ for UK.
But I also need to list $ and Euros.
Euros is already there as a separate entry in the properties.
ANy way to add dollars?

 

[Rabbie]

You should be able to create a custom format to display the dollar fields. See this link for some advice