Character limit for a field in the report

[JayZee]

Hi everyone!

I am a baby when it come to Access and we just upgraded to the 2013 version last week so I am all kinds of lost. My stuff is pretty basic but I have a problem I can't fix. I hope you can help.

In my table, I have a field for "notes" and have it set to long text. It works just fine and has all the text visible. When I create a report or a form from this table, it truncates the text in that field. It limits to the 254 characters of old. I am not sure how to fix this. I have tried setting the WillGrow to yes and it still does not work.

Any suggestions are appreciated.

Thanks!

 

[JHB]

I'm not used to MS-Access 2013, but in MS-Access 2010 in a report, you've to set the property "Text Format" for the control to "Rich Text".
What is the record source for the report a table or query?

 

[burrina]

You can set the limit via code. Example:

 Validation Rule =Len("Specification")

<1000

A Memo field can store up to 65,536 characters.

 

[JayZee]

Thanks everyone. I think Rich Text was the culprit. The data was exported from an excel sheet and some was entered into table itself. So far the records seem to be showing all the text. I did not think Rich Text would be the answer since the information in the field is simply text - live and learn. Thanks again!

 

[JHB]

You're welcome - good luck.

.. - live and learn.

Yes