Memo field impossible to print in report

[Tracy]

Hi,

I have a memo field in a table, and when set this table to the record source of a report, and set the memo field as the control source of a text box on the report, the memo field gets truncated.

I've even tried to use two separate text boxes and set their control sources to =Mid([MemoField],1,250) and =Mid([MemoField],251,500) respectively, but still the second filed truncates (after 10 characters or so).

Surely even Access has a facility to print memo fields that are greater than 250 in length.

Please can anyone help me?
Thanks v much.

 

[Rich]

I suspected the query was truncating the Memo, try using DLookup , just another guess this may be a side effect of the auto correct feature, try turning it off if your in A2K

 

[llkhoutx]

Set the "Can Grow" property of your report memo field to "Yes."