By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,271 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Putting pound sign on the currency format

P: 32
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
Share this Question
Share on Google+
5 Replies


JConsulting
Expert 100+
P: 603
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
Expert 5K+
P: 8,669
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

P: 32
Thanks all for replying, the field format was currency...and the control panel solution worked....Nanda
Aug 5 '07 #4

P: 1
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
Expert Mod 5K+
P: 5,397
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, 6889 views)
Jan 20 '16 #6

Post your reply

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