Problem getting Memo to a file

[ipellew]

Hi;

I have a DBS that uses Memo's, no suprise there.

I have code that gets each row's memo's to form a javasript line.
I find long memo fields get corrupted to hell after about byte 280.

Suggestions Pls.

Access 2002 Code fragment:-
.....
Set db = CurrentDb
Set qd = db.OpenRecordset("SELECT * from Q_exp")
.......
os = qd.Fields(0) & "|" _
& qd.Fields(1) & "|" _
.......
& qd.Fields(7) & "';" _
.......
Print #fno, os

Regards
Ian

[ipellew]

Hi

I found this by working a workaround after reading lots of threads on
memo's.

The export came from a query that had the function on each of three
memo fields to convert the CR to \n.

By putting these replaces into my form code and <print>ing to a file it
works fine.

Access 2002 is bugfgie around memo's and should not be relied on.
I consider I was doing nothing I should not, but then that Bills and
his merry folk.

Regards
Ian

[Lyle Fairfield]

ip*****@pipemedia.co.uk wrote:

Access 2002 is bugfgie around memo's and should not be relied on.

I wonder why so many of us have no problem with memo fields? Strange,
eh?