truncating even though using memo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have imported data from Excel into an Access database. Even though I have
changed the data type from "text" to "memo" / insured that the "can grow" is
selected my data is still truncating in my report. What am I doing wrong?
 
I think you’ve probably been bitten by a known bug which can unpredictably
cause this behaviour when a control bound to memo field is added to a form or
report from the 'field list' or the report or form is created with a wizard.

The solution is to delete the bound text box from the report in design view,
then add a new text box from the tool box and set its ControlSource property
to the name of the memo field.

If you do this with a form also set the text box's EnterKeyBehavior property
to 'New Line in Field'.

Ken Sheridan
Stafford, England
 
Back
Top