A
Andrew Parkinson
I've tried to narrow down my problem:
I've cut out the SQL and started later in the process.
Create a simple table in access with one column (data type
text) and typed "test£" straight into the first and only
row. Created a simple report with one field that reads
this table data. Created simple form with one button that
prints this report as before to the specified folder. When
I open this file in notepad the text reads "testœ" and
not "test£". Yet if I add code to view the access report
on screen just prior to printing, the field still
reads "test£". The problem must be in the way the report
is exported to a text file. (Output To format selected is
MS-DOS Text).
I've cut out the SQL and started later in the process.
Create a simple table in access with one column (data type
text) and typed "test£" straight into the first and only
row. Created a simple report with one field that reads
this table data. Created simple form with one button that
prints this report as before to the specified folder. When
I open this file in notepad the text reads "testœ" and
not "test£". Yet if I add code to view the access report
on screen just prior to printing, the field still
reads "test£". The problem must be in the way the report
is exported to a text file. (Output To format selected is
MS-DOS Text).