469,126 Members | 1,276 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

Putting pound sign on the currency format

Hello,

I have a currency field on my form. The default formats for this field are dollar, euro. There is no pound symbol.....How do i put in a currency format, having the pound sign.

Any help will be appreciated.

thanks and regards
Nanda
Aug 5 '07 #1
5 22226
JConsulting
603 Expert 512MB
Hello,

I have a currency field on my form. The default formats for this field are dollar, euro. There is no pound symbol.....How do i put in a currency format, having the pound sign.

Any help will be appreciated.

thanks and regards
Nanda
This is not an Access issue. You must go into your control panel and set the regional and Language options to English(united kingdom).
J
Aug 5 '07 #2
ADezii
8,800 Expert 8TB
Hello,

I have a currency field on my form. The default formats for this field are dollar, euro. There is no pound symbol.....How do i put in a currency format, having the pound sign.

Any help will be appreciated.

thanks and regards
Nanda
  1. Define the Data Type of the underlying Field in the Table to Currency NOT Text.
  2. Set the Format Property of the Text Box that will display these values to Euro.
  3. The figures will now automatically de displayed with the Pound Sign.
  4. More than likely, you have the Field's Data Type set to Text, which is why the sign is not being displayed.
Aug 5 '07 #3
Thanks all for replying, the field format was currency...and the control panel solution worked....Nanda
Aug 5 '07 #4
Hi,
No need to change the regional and language setup...
Just type £# in currency format.. it will the change currency in to sterling ...
Jan 20 '16 #5
zmbd
5,400 Expert Mod 4TB
venkateshigcse
Your suggestion does not work for fields that are set to the currency data type.
>> This is a regional setting as per both JConsulting and ADezii for fields assigned to the currency data type.

Proof of point, I am in the USA, my regional setting is of course USA currency. As you can see from the following image, attempting your suggestion results in a table level error:



Of course, if I change the region to UK, the error goes away and the pound sterling is accepted.
Attached Images
File Type: jpg 688240_RegionalCurrencySetting.jpg (28.4 KB, 7866 views)
Jan 20 '16 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Robert Zierhofer | last post: by
4 posts views Thread by ben | last post: by
5 posts views Thread by Waldy | last post: by
2 posts views Thread by Dalan | last post: by
3 posts views Thread by news.shaw.net | last post: by
2 posts views Thread by Bob Dydd | last post: by
4 posts views Thread by Gerry Abbott | last post: by
4 posts views Thread by Kun | last post: by
4 posts views Thread by monomaniac21 | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.