Text box size limit

[NeilT123]

I have a text box on a report which the source is a memo field. The text box does not show the whole content of long memos. The contents are definitely in the table but just do not show on reports.
Is a text box limited in size to approx 250 characters?
If so how do I get around this?

 

[lupins46]

If you have any formatting symbols in the textbox in the report remove them.

After that it's a case of looking at your report recordsource .
If it's a query, then run the query and do a Shift_f2 (Zoom) where you would expect to see a long entry and see if the data is in the query.

 

[dhookom]

I think this has been resolved in another thread where NeilT123 removed a "GROUP BY" from the record source.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]