Memo Field in Report

[rmr]

Hi,

I have a memo field in a report but it does not show all the text in that field. It is showing a mximum of 245 characters. The text box can grow and there is more than enough space. I can't find anything in properties etc.

Any ideas?

Many thanks.

 

[KatCanDo]

Memo Field size

A Memo field can store up to 65,536 characters. What is the source of your report?

If table go to design view and change data type to Memo.

 

[rmr]

Hi katcando,

The data type in the table is memo. The report is run off a query. After you saying this I checked the query and the field in question was cutting short the text in that field.

I realised the query had Totals selected. I took that off and now all the text appears!!

Great - thanks.