Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2013

    Unanswered: Field Size Limit

    I have a field that is limited to 255 characters. Is there a way to increase to say 500 characters?

    It is set up in the table as "short text". When I try to change it to long text I get a message saying it is not supported for this type.

    Thanks for any help

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    255 is the limit for a Text column. The only thing you can do is to switch from Text to Memo. Be aware that there are several restrictions when using Memo columns (see Access help).
    Have a nice day!

  3. #3
    Join Date
    Aug 2013
    In Access 2013 the memo field is now called "Long Text". The field in question is for documenting the details of a repair and I just need some more characters.

    I tried to change the data type but I get a message saying that data type is not supported (long text).

    Does this have to do with the relationships of the tables?

  4. #4
    Join Date
    Aug 2013
    I figured out what I was doing wrong. My database is split and I tried to alter the front end which is incorrect. I went into the backend and changed the field to long text.

    Sometimes the easiest solution is too obvious.

  5. #5
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Quote Originally Posted by Sinndho View Post

    ...Be aware that there are several restrictions when using Memo columns...
    In line with that, be aware that one of the Cardinal rules to having a well designed, normalized database is that no single field will contain more than one individual piece of data. Data stored in Memo fields should be restricted to "notes" or narrative type information, such as a salesman's notes on a customer visit or a doctor's progress notes on a patient.

    Working primarily in a Heath Care environment, I've used Memo fields extensively for a number of years, without ever having a problem. The secret is to follow one single rule:

    Never, never, never place data in a Memo field if there any possibility that you will ever need to search, sort, parse or in any other way manipulate the data!

    Because many Queries perform some of these functions, you have to take care in using them in Queries or they will be truncated to 255 characters.

    Allen Browne has some excellent advice explaining how to deal with Memo Fields and Queries:

    Microsoft Access tips: Truncation of Memo fields

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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