Share via

Microsoft Access 2016 Long Text limited to 255 Characters

Anonymous
2017-02-20T06:57:47+00:00

Hi,

I am using access 2016. I have imported the table from an excel sheet and has been working on it for a year. I have remarks column which I set as Long Text but recently I noticed that my inputs to that column has been truncated. I have tried all the available solutions on the web (I really mean ALL SOLUTIONS) but couldn't solve. I have tried removing "@" sign from Format, changing "Plain text" to "Rich text", I deleted that column and created new column again to input the data inside. But nothing is solving the problem. Still the field can't take more than 255 characters. Can anyone help me out this?

Thanks

***Post moved by the moderator to the appropriate forum category.***

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-02-20T12:49:42+00:00

    I first encountered this problem many years ago in Access 95.  Firstly, you should never enter data in a table's raw datasheet, only via a form.  This is true regardless of this issue.  When designing the form do not drag the field from the field list to the form, but add a text box control to the form and set its ControlSource property to the name of the field.  Change the text box's EnterKeyBehavior property to 'Next line in field'.  This has always worked for me.

    If you've used the form wizard to create the form, delete the control from the form and add a new one as above.

    Do the same in any report which returns the field.

    Was this answer helpful?

    10 people found this answer helpful.
    0 comments
  2. Duane Hookom 26,825 Reputation points Volunteer Moderator
    2017-02-20T11:26:47+00:00

    I would first make sure there isn't a space in the Format property. 

    Are you able to add more than 255 characters using an action query?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments