Are there 'memo' datatype limitations?

[qu1ncy]

Hi,

Hope someone can shed some light on this problem.

I have an multiuser Access 9.0 database using a "memo" field in one of it's tables. Users employ this field much like a forum. A specific business procedure is reviewed by the group with each member adding text using a form front end. The table stores it all!
One user who creates reports on this data can view everything in this field using the form or locating the record in the table. However, when she tries to produce a report which includes this field, the report cuts off the data.

The field "can grow" property is set to 'yes'. The field text box physical size in the report should not be an issue here as text is spread over many pages, but suddenly stops.

The 'reporting' user's workaround to this problem is going into the table, specific record's memo field, and copying. She then pastes the text into a Word document and ends up with a 6 page document which she staples to the report. Not really convenient but this issue is a rare occurance so she doesn't mind.

I've snooped in facts & forums which has revealed the 'memo' datatype to be limited to 65,536 characters. Is not the issue here. I'm at a loss... Any suggestions and/or help is appreciated.
Thanks in advance.

Q

 

[kmayo503]

I have heard the same about the limit of 65,536 characters, but in access it is the highest character field at least that is what i am told from some of these other programers.