Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    field dropping text in my report (access 2002)

    Hello everyone - I have a report in access with some fields that hold text. For some reason when my text is especially long access decides to just drop it.. like what happens when you paste a long text string into excel (over 255 characters). My field is set to grow and I have other fields on this report that are working just fine with even more text. Any ideas!

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Frederick, Maryland, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: field dropping text in my report (access 2002)

    I assume you use a query for your report data and that the text fields in question are populated by memo fields in the underlying table. Access truncates memo fields to 255 characters when used in queries. This is a frustration that many of us have had to work around.

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

    Re: field dropping text in my report (access 2002)

    Huh? <img src=/S/confused.gif border=0 alt=confused width=15 height=20> Is this new in Access 2000 or XP? I use memo fields (sparingly) in Access 97, and the full text is available in queries and in forms/reports based on those queries. Honest! I just checked it.

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Frederick, Maryland, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: field dropping text in my report (access 2002)

    I just went through this with an application I'm developing. I developed a query that involved a memo field and was only getting the first 255 characters. After several posts in the Lounge, I was finally informed of this limitation, cursed a little, then moved onto the next challenge!

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

    Re: field dropping text in my report (access 2002)

    Ah, I found it (<!post=Post 88815, 88815>Post 88815<!/post> and answers to that). If you apply formatting to a memo field, it is truncated to 255 chars.

    Just including a memo field in a query seems to be OK. That's my experience, at least.

  6. #6
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Frederick, Maryland, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: field dropping text in my report (access 2002)

    Thanks, Hans. I had forgotten about the formatting limitation. Sorry if I confused anyone.

Posting Permissions

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