Memo field Truncation

[Tom]

Any advise/suggestions on how to overcome the following would be
appreciated.

Using Access 2002 we export a table to access. One of the fields is a memo
field and we are finding that, on export, only the 1st 255 characters are
exported.

How can we export all characters in that field?


TIA

Tom

 

[Guest]

Tom:

Its possible the data might not in fact have been truncated but only appear
to be so due to a bug which has been around since at least Access 95 in my
experience. I first encountered it when importing dBASE files. The text
appears to be truncated in datasheet view of the table or in bound controls
on a form or report added by dragging from the field list or if the form is
created with the form wizard.

Try creating a form or report bound to the table and adding a text box from
the Toolbox. Then set the text box's ControlSource property to the name of
the memo field. You might well find that al the text shows. In a form you'd
probably want to change the control's EnterKeyBehavior property to 'New line
in field', which is the normal setting for memo field controls.

Ken Sheridan
Stafford, England

 

[Tom]

Thanks Ken that sorted the issue

Tom

Tom:

Its possible the data might not in fact have been truncated but only
appear
to be so due to a bug which has been around since at least Access 95 in my
experience. I first encountered it when importing dBASE files. The text
appears to be truncated in datasheet view of the table or in bound
controls
on a form or report added by dragging from the field list or if the form
is
created with the form wizard.

Try creating a form or report bound to the table and adding a text box
from
the Toolbox. Then set the text box's ControlSource property to the name
of
the memo field. You might well find that al the text shows. In a form
you'd
probably want to change the control's EnterKeyBehavior property to 'New
line
in field', which is the normal setting for memo field controls.

Ken Sheridan
Stafford, England