Data corruption problem Access03

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a table with several memo fields that display the entered data
correctly; queries on the table also display the returned data
correctly. I can copy and past the data from the fields into notepad,
and it displays there correctly as well.

However, when I write the data to a text file (Print #1, qry!
[FieldName]) the first 255 characters are rendered correctly, but all
characters beyond 255 are garbled (question marks, undefined
characters such as ANSI 0, 1, [Space] 32, and a couple of stray alpha
characters).

I have used this technique in other applications for many years with
no problem, and this one is stumping me.

Any suggestions?

Thanks
Dave
.

Relevant Pages

  • P9 Fonts in display...?
    ... If I use proportional fonts in P9, ... nuisance to see the characters "compressing" in memo fields ... When I use Andale in MS Word, there is no display difficulty ... of the characters as the long string displays. ...
    (comp.databases.paradox)
  • Meme Fields only display 255 CHARS
    ... I have created a report from a querie. ... I have 4 memo fields. ... Print Previewed in the Report only display the first 255 ... characters. ...
    (microsoft.public.access.reports)
  • Memo Fields Only Displays 255 Characters
    ... I have created a report from a querie. ... I have 4 memo fields. ... Print Previewed in the Report only display the first 255 ... characters. ...
    (microsoft.public.access.reports)
  • gforth: SDL/OpenGL Graphics Part VIII
    ... There are times when all you need is the simple 8x8 font that we had ... want to use the original PC font text line characters. ... TTFs to the display are too much when you just want to "do it". ... sets the cursor x coordinate. ...
    (comp.lang.forth)
  • Re: Character max
    ... "Peter Jamieson" wrote: ... is there any way to avoid using the Access VBA function in your query? ... this might be where the problem lies as the 25 first memo fields all ... breaking after 255 characters used to be commonplace. ...
    (microsoft.public.word.mailmerge.fields)