œ symbol on export, require £ symbol

[DeanRowe]

Hi,

I'm trying to export a report to a text file. The report contains a pound "£" symbol, however when it is exported into a .txt file the symbol appears as a "œ".

Does anyone know how I can stop this from happening, or the symbol that would make a "£" appear.

Thank you.

Dean

 

[georgedwilkinson]

You didn't mention what country you are in.

Can you just copy/paste it from the Character Map?

Also, on my US keyboard, I can hold down <Alt> and type 0163 on the keypad to get a pound symbol.

 

[DeanRowe]

Sorry George, I'm in the UK, the "£" symbol is on the number 3 key on our keyboard.

Currently I have code on my report that looks like this:

="Total Inc VAT & Delivery: £" & [TotalIncVAT]

When its viewed as a report it shows this:

Total Inc VAT & Delivery: £126.76

However when I export the same report to a txt file it looks like this:

Total Inc VAT & Delivery: œ126.76

Any ideas of what symbol to use in place of the "£" - I'll never need to view the report in access or print it out - I'll only ever view the txt version.

Thanks George.

Dean

 

[Rich]

The question has to be why you need the symbol added in that way at all

 

[DeanRowe]

Hi Rich,

We used to fax our orders over to our supplier - so when the order was complete a command button printed out a report with various data. However our supplier now requires them to be emailed rather than faxed - so I've changed the coding to export the report into a txt file that pops up, we then simply copy and paste it into an email and send the order off.

However because the £ is appearing as a "œ" it means we are having to delete them and replace them with a £ manually - it's not a major task but it's a little annoying and it'd be far easier to have it load up with the £.

Any ideas?

 

[Rich]

If the field in question is defined as currency then the £ symbol should be displayed automatically, either way it sounds as the the formatting should be in the underlying query

 

[gemma-the-husky]

is your windows regional setting definitely UK?

 

[Jofffox]

Hi dean,
i am having the same problem when exporting report to text file, did u ever find an answer?

thanks
Jon

 

[DeanRowe]

Hi Jon,

No I'm afraid I've had to live with it so far. As Rich suggested, I would have thought that changing the underlying field to currency would resolve the problem. However I had a previous problem where the rounding up and down of calculations wasn't working properly, it took me absolutely ages to sort out using a code in each of my queries, so I'm not even going to attempt to fiddle with any of that incase it messes it up again.

The only idea I had, but haven't had the time to try, was entering every single symbol, such as !"$%^&*(()_+?><{~, into the report and hoping that one of them would produce the "£" that I needed.

Sorry I couldn't help Jon, if you do have any luck I'd appreciate it if you could post it here and let me know.

Thanks Jon.

Dean

 

[Rich]

post the code you used to resolve the rounding issue

 

[DeanRowe]

Anyone had any luck with this problem yet? I've tried typing in lots of random symbols but no luck a yet.

 

[Rich]

You haven't answered the previous post yet

 

[wiklendt]

why don't you 'print' the report from access direct to pdf? then attach the pdf to the email? you can get free utilities which act as printer drivers, so it pretends to be a printer on your system, so anything you can send to a printer, you can 'send' to pdf... i do it all the time, it's fabulous.

 

[DeanRowe]

I did used to print to pdf and then send the pdf in an email to our suppliers, however they complained that they couldn't select the text and copy it to easily load it into their system. So I changed the macro to "output" the report to a text file, which then opens up automatically and I copy and paste the outputted report into an email and send it to them.

BTW, here is the code I used in a query to solve the rounding issue I had:

Total Buying NET: Round([Buying Price Net]*[Quantity],2)

Thanks for your time everyone.

Dean

 

[DeanRowe]

does anyone have any ideas yet? I've tried entering in every symbol that I can see on the keyboard but none of them result in the "£" symbol.

 

[Deleted member 30250]

Have you tried Alt-156?

Character set problems gave me a lot of my grey hairs. I have ú cropping up for £ when I import from Lotus Approach, and they get œ in Approach sometimes, for no reason I've been able to fathom yet! £ ought to be what you get for Alt-163, but Alt-156 also seems to be £.

Yours,
Confused but persevering!

 

[wiklendt]

from the office website:

I'm having problems displaying international characters.

• Your data may be stored in OEM format and the conversion setting is wrong. To determine whether data was stored in OEM format, you can use a query to display the contents of the tables you are working with. If extended characters appear incorrectly, the OEM conversion setting is probably wrong. Close the Access project, change the setting in the SQL Server Client Network Utility program (under the DB Library Options tab), and then re-open the Access project.
• You may see unexpected behavior if the system code page of client machines doesn't match the character set of the SQL Server. On the client, the system code page is the character set that is used by the language specified in the operating system; if you are running Windows 2000 or later, this is the Default Locale. On the server, the character set is specified during SQL Server installation. In an Access project (*.adp), query results containing ANSI text fields are not displayed correctly if the system code page of the client computer does not match the character set of the SQL Server to which the client is connected. This problem does not occur for data that is stored as Unicode on the server.

 

[wiklendt]

looks like you need Windows ISO/IEC 8859-1 (Latin 1) coding, or unicode as comes up on my character map.

A3 = U+00A3 : POUND SIGN

Alt+0163

as far as i can tell, the pound symbol is producible by using the Chr(156), though on my system this returns "œ", so i think it has something to do with my previous post (character encoding in access/windows). i have had a VERY quick look in my Access 2007 program and cannot find where to change this (Language/Region settings in windows control panel may help).

a google search for your particular version of access may help you.

more info on the pound symbol:

http://www.fileformat.info/info/unicode/char/00a3/index.htm

also i don't know if this will help (don't have time to read it), but there's some info here too:

http://www.fileformat.info/tip/microsoft/enter_unicode.htm

i got all this info from google in about 20 minutes. you need to do some researching for yourself rather than expecting to sit while others find the answer for you.

 

[wiklendt]

Alt+163 is probably/could be the lire symbol (same as pound symbol but with two strokes instead of one....) i can't check on my sys b/c i don't have the time to play with chainging character coding at the moment...

 

[wiklendt]

what's strange is that alt+0163 in my system displays the pound symbol, but chr(156) does not. you just have to play around with which character set you use and make sure the application to which you are exporting is the same. i guess.