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

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.

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

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

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 &#163; is appearing as a "œ" it means we are having to delete them and replace them with a &#163; 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 &#163;.

Any ideas?

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

is your windows regional setting definitely UK?

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

thanks
Jon

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

post the code you used to resolve the rounding issue

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

You haven't answered the previous post yet

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.

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

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 "&#163;" symbol.

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!

from the office website:


http://office.microsoft.com/global/images/default.aspx?AssetID=ZA790050011033I'm having problems displaying international characters. (javascript:ToggleDiv('divExpCollAsst_7'))


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.

looks like you need Windows ISO/IEC 8859-1 (Latin 1) (http://www.microsoft.com/globaldev/reference/iso/28591.htm) 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.

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...

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.

Thank you very much Robjoy, the Alt-163 worked perfectly.

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, you have no idea the time I have spent trying to figure out this problem, no idea. I had found the information you had mentioned on Google, and plenty of other information - but messing around with underlying database properties that I do not fully understand was not the way to go. I posted in this forum to see if anyone else had had this experience or ideas, fortunately Robjoy did.

I appreciate that people probably take the mikey on this site and post problems without researching them, however I do not appreciate your comments as I researched this problem countless times and was simply asking for help - if you don't want to post without leaving arsey comments then don't post.

Aside from that comment I do appreciate the time you spent looking into this problem, as you did clearly spend a lot of time looking into this - and came to the correct answer also. So thank you very much for your time wiklendt.

how about

="Total Inc VAT & Delivery: " & chr(163) & [TotalIncVAT]

?

i didn't mean to be rude. i apologise.

i must point out that you had given absolutely no indication i njyour posts that you had googled the problem, which keywords you used and what you found and no indication that you had search anywhere else for information - so to me it appeared as though you sat around for a while, because that's all that was apparent in the thread.

i appreciate you have probably spent lots of time on your problem (i know from personal experience! LOL), but if you don't make that apparent to the rest of us, it's a bad look and can be taken the wrong way.

this is what people expect to see is apparent in the posts, otherwise it posts look flaky:
http://www.access-programmers.co.uk/forums/showthread.php?t=149429

and here's a funny thread about it too ;-)
http://access-programmers.co.uk/forums/showthread.php?t=85042

as for me not answering questions, i am happy to answer questions and offer advice/info - but i am (and many others are) MUCH happier doing it when they can *see* people have put in the effort (again, i accept that you've spent time on this, but again, you have to make it apparent.)

(having said all that, i think i should point out that you HAVE done a LOT more than i've seen other people do, BUT if you have spent time search google, you need to say so!)

not sure if it's any help, but i've had problems as I have to deal with many currencies and many number formats.

I've had to create a table with explicit number formats for countries I deal with.

My reports are coded to use this number format


Private Sub report_open(Cancel As Integer)
Dim Cformat As String
Cformat = DLookup("currencyformat", "tblagency", "agencyID = [forms]![frmnavigation]![masterfilter]")
txtPrice.Format = Cformat


currencyformat: has values such as tblAgency tblAgency CurrencyFormat "US$"#,##0.00 £#,##0.00 "MOP " #,##0.00

When I export my report to plain text, all of the appropriate currency symbols and formats appear as they should.

I am using office 2007 & windows vista, so perhaps they're a little more up to date with unicode. I'd take a guess that the results might not be the same on a XP system or an earlier version of access.

haha - problem solved i see.

people on this forum are waaay too quick! :-D

I do see your point wiklendt, and had never looked at the situation from that side before - lesson learned. Thank you again for your help.

no worries - i learnt the same way you just did - by someone yelling at me ;-)

good luck with the rest of your project.

flect, what a great idea to have a table of correct formats!! that's the best idea i've seen in a while (never having thought about it before :-P ).

Thanks Wiklendt! I'll claim credit for putting it in a table - but credit goes to the help received from this forum to actually get it working!!!

Great to see another Aussie on here too!

:D