œ symbol on export, require £ symbol

[DeanRowe]

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.

 

[Darth Vodka]

how about

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

?

 

[wiklendt]

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

 

[wiklendt]

(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!)

 

[flect]

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.

 

[flect]

haha - problem solved i see.

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

 

[DeanRowe]

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.

 

[wiklendt]

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

 

[flect]

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!