Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    working with a long string (Access 2003, XP SP 3)

    one aspect of this project is to evaluate a 1812 byte string. It appears that there are issues with getting the entire string to stay on one line, and this *may* be effecting the program's ability to function correctly. is there some kind of internal limit in Access Memo fields on storing a long string? when i examine the string it appears that a break is inserted at position 1018 and the rest of the string follows on another line.

    ??

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: working with a long string (Access 2003, XP SP 3)

    According to Specifications for an Access database and for an Access Project, a memo field can hold up to 65,535 characters entered manually ( <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15>) and up to 1 GB of character storage through VBA. So 1812 characters shouldn't be a problem.

    As a test, I pasted a 2668 character string into a memo field, and no line breaks were inserted. So I'm not sure why you have problems with a memo field. Are you sure it's a real line break?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: working with a long string (Access 2003, XP S

    actually i'm being stoopid. i just double-checked the source data and it has those line breaks. so it isn't Access "per se" having a problem. something else is causing an issue. i can call the DLL and pass data to it but the DLL is being grumpy.

    Sorry!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •