By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,553 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Problem getting Memo to a file

P: n/a
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

Jul 22 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Jul 22 '06 #2

P: n/a
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?

Jul 22 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.