Share via

access data type "long text" only allows 255 characters. What's wrong???

Anonymous
2013-06-20T23:13:37+00:00

Help trying to enter notes into access field.  I've entered data type as "long text" but it will only allow me to enter 255 characters as if it was a "short text" data field.  Any ideas???  Thanks. Emma&me

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

16 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-06-21T15:32:28+00:00

    Tom,

    Problem solved!!!  For some reason data type listed "long text" but I noticed on property sheet the format had a "@".  I deleted it and long text field accepted more than 255 characters.  Now my only question is what does "@" do besides give me grief and how did it get into format???  I am loving learning the Access program.  Wish I had discovered it years ago.  And thanks for being here and helping us.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2017-12-14T16:06:25+00:00

    Help trying to enter notes into access field.  I've entered data type as "long text" but it will only allow me to enter 255 characters as if it was a "short text" data field.  Any ideas???  Thanks. Emma&me

    Good, solved: @ deleted and... wow... OK. Sure

    I am having the same problem.  I took out the @ sign, but am still only able to enter 255 characters.   Is there any other solution??

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2013-06-22T00:49:48+00:00

    Nice detective work!

    Yes, formatting a string can override the length. I would call this a bug, but I'm afraid MSFT disagrees.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  4. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2016-07-04T17:04:09+00:00

    You typed it in. Accidentally, most likely.

    Since you are trying to learn, I'll just point you to the Help file, topic Format Property - Text and Memo Data Types

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  5. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2013-06-21T01:54:37+00:00

    Hmm, that's surprising. And this is a standard Access 2013 table?

    This is a client app, not a web app, right?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments