Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts

    How to Increase Memo Length

    Hello,

    This is my first post in this forum and am new to MS Access. Am inthought of to gain some knowledge through this forum.

    I have created a table in which there is one column of type memo. When I copy the content in this column it is allowing me to enter only 255 characters. How to increase the length of this column type memo?

    I have created a query with GroupBy. Is it causing me the damage? How to oversome this situation.

    Need your valuable suggestions on this.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Welcome to the Windows Secrets Lounge and the Databases forum - you will find many knowledgeable and helpful members here.

    The GroupBy query is the source of your issue - if you do that kind of query or if you sort by that field, you will see the data terminated at 255 characters. There are some complex internal reasons for that constraint - so the usual advice is to sort or group by a truncated version of the field, and then include the field as another column in your query.
    Wendell

  3. #3
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Could you kindly elaborate your above post.

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    Is it not allowing you to enter more than 255 characters, or is appearing to be truncated sometime after the fact?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    Star Lounger tgw7078's Avatar
    Join Date
    Jul 2010
    Location
    Seattle, WA., USA
    Posts
    90
    Thanks
    1
    Thanked 12 Times in 12 Posts
    Check out these links:

    http://allenbrowne.com/ser-63.html

    http://allenbrowne.com/bug-18.html

    http://allenbrowne.com/QueryPerfIssue.html
    In this last article, see the section titled "FIRST versus GROUP BY". Note that you are free to change the default aliasing, by entering something unique, separated by a colon. The field alias must be unique, and cannot be the name of another field available to the query.
    Tom Wickerath
    Microsoft Access MVP
    4/1/2006 - 3/31/2012

  6. #6
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks. Got it.

    I changed the groupby to first and my memo field seems to be perfect.

  7. #7
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts
    It's going to be truncated after 255 charecters.

    I changed the memo field to first and it's working now

Posting Permissions

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