Problem getting Memo to a file

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • ipellew@pipemedia.co.uk

    #1

    Problem getting Memo to a file

    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.OpenRecordse t("SELECT * from Q_exp")
    .......
    os = qd.Fields(0) & "|" _
    & qd.Fields(1) & "|" _
    .......
    & qd.Fields(7) & "';" _
    .......
    Print #fno, os

    Regards
    Ian

  • ipellew@pipemedia.co.uk

    #2
    Re: Problem getting Memo to a file

    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

    Comment

    • Lyle Fairfield

      #3
      Re: Problem getting Memo to a file

      ipellew@pipemed ia.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?

      Comment

      Working...