Text box truncates to 255 in all reports

[Squidlo]

Hello, I am new here and a novice access user so I thank you in advance for your patience and understanding.

I use an Access database at work and there is little technical expertise for support. I have been using this database (or a copy of) for the last few years. I am not sure what happened or when but the problem now is that when you try to run a report (that I've ran a hundred plus times in the past) the text boxes only display 255 characters. The big question is what changed. I asked my team and the only logic is it happened during the annual transition when the database is copied into the next year and the CA table auto number is reset. We think that this started around this time. I was told the process used to reset the auto number was a combination of information found here support .microsoft. com/ kb/ 812718 and use of compact and repair.

So it was found that both the 2013 and 2014 databases are having this issue. We are hoping to avoid have to revert back to the 2012 database and import all the data and items (queries reports etc.) that have been created over the last two years.

Any assistance or insight would be greatly appreciated.

 

[JHB]

Is the data in the table also cut down to 255 characters?
Check if the field in the table is a "Memo" field type.

 

[Squidlo]

The fields in the table are memo and there are some records with 1000+ characters listed in the fields, they just do not show up in the report.

The copy of the 2012 database does not display this behavior so I had previously compared the tables and report properties with the 2013 hoping to find what changed but could not. I then realized I needed to take a closer look at the query properties and there it was. Unique Values was set to yes. When I changed it to no we were back in business.

Thank you to all for your efforts.

 

[twitchie]

This may be too simple a solution, but do you have the Can Grow set to Yes on the field's properties on your report? A Memo field type should hold many more than 255 characters. Have you looked in the table to see if there are more than 255 characters being stored? If so, it's a display issue with the memo field on your report. If not, then you'd need to start with the field parameters itself.

 

[twitchie]

This may be too simple a solution, but do you have the Can Grow set to Yes on the field's properties on your report? A Memo field type should hold many more than 255 characters. Have you looked in the table to see if there are more than 255 characters being stored? If so, it's a display issue with the memo field on your report. If not, then you'd need to start with the field parameters itself.

LOL, missed your solution. Withdrawn.