Convert .xls to .prn problem

[Irene Titkov]

I wrote a macro in Excel that extracted records from the Access databas
and saved the output as .prn file. It's been working fine for a fe
months. Yesterday the users came across the following problem. One o
the fields in the database is two character long. If that fiel
contains IF, F is dropped when converting into .prn. I tried all kind
of different character combinations, e.g. IS, IN, IY, etc. Works OK
But if it's IF, it's saved as I. Has anybody ever experienced this

 

[Dave Peterson]

The only way I could duplicate parts of this was to make the columnwidth too
narrow to show all the characters.

Or if I ran out of characters per line (240 max per line in the .prn file).

If you change the font to courier new and autofit the columns, do you get what
you want?