Putting pound sign on the currency format

[ramaswamynanda]

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

[JConsulting]

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

[ADezii]

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.

[ramaswamynanda]

Thanks all for replying, the field format was currency...and the control panel solution worked....Nanda

[venkateshigcse]

Hi,
No need to change the regional and language setup...
Just type £# in currency format.. it will the change currency in to sterling ...

[zmbd]

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.