Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Truncated Memo Fields (O2k SR1a, Win98SE)

    Have searched but can't find answer. Am getting truncated data in a form with several memo fields. There are vertical scroll arrows in the fields, but something is limiting the number of characters that can be entered. Entry just won't take any more! (Guess it's fed up.)

    My practice is to build forms from queries which are derived from tables. Have traced fields back to the tables and verified that they are in fact memo fields.

    The fields refuse to take more than around 240 - 250 characters. Since I haven't used memo fields much in the past I'm stumped.

    Perhaps some of you know of some resources I might check or -- even better -- know the answer.

    Thanks,

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Truncated Memo Fields (O2k SR1a, Win98SE)

    Chances are you have a sort or some other sort of action running against the record source you are using for the form. Any field that is being sorted or otherwise used in any kind of Grouping query will be limited to 255 characters give or take. If that turns out not to be the case repost and we'll see if we can come up with other scenarios.
    Wendell

  3. #3
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Truncated Memo Fields (O2k SR1a, Win98SE)

    Another possible cause is applying any kind of formatting to the memo field, which causes Access to treat it like a text field (ie, 255 characters max). Recommend check form, query or table for any such formatting. For details see MSKB article Q259893:

    ACC2000: Formatted Memo Field Appears to Truncate Data After 255 Characters

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Truncated Memo Fields (O2k SR1a, Win98SE)

    Wendell and Mark:

    Thanks for the responses.

    Mark ... you hit the problem on the head. I had used the 'greater than' sign to force caps display in the field.

    Thanks again,

Posting Permissions

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