Entering text in a table field

  • Thread starter Thread starter Newbie64
  • Start date Start date
N

Newbie64

Hi,

I was typing a long text in a table field in Access named "Status". The field
length is set to 255 characters.

I received a message "The string returned by the builder was too long. The
result will be truncated."

How can I correct this error so I can continue to enter the text in the table
field name "Status".

You can e-mail me directly (e-mail address removed) with your answer.
 
I was typing a long text in a table field in Access named "Status". The field
length is set to 255 characters.
Click to expand...

Change the datatype from Text (255 characters max) to Memo (65536 characters
if you type them in a form, over a gigabyte if you fill it programmatically).

John W. Vinson [MVP]
 
Back
Top