£ symbol being replaced by œ in outputted text

[Torq]

Hi,

I have an unusual problem which I can't seem to solve. I have a report built up from sub reports containg product information (name, title price etc..) which I deliver in text format to the Marketing department.

The report looks fine when I view it in Access (except for the extra spacing), but when I view the outputted text file in Notepad all the £ symbols have been replaced with the œ character.

I use a macro with the Output To action and the Output Format is MS-DOS text. Any ideas?

Simon

(using Access 2000)

 

[DrSnuggles]

Why not use the Snapshot Viewer?
Unless you're doing further data manipulation on it.

 

[Torq]

Unfortunately the file does need to be edited by the marketing guys afterwards, to add in some further data.

 

[DrSnuggles]

Haven't really used the Output To action, usually write to a text file from VBA.
Do you know how to do this?

 

[Torq]

Embarrisingly no. My VBA skills are pretty rudimentary, and file manipulation is not amongst them.

Do I need to write the report out as a text file?
Any pointers you can give on the code needed?

Thanks for your help so far.