Entering text in a table field

[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.

 

[Guest]

If you need more than 255 characters then use a memo field.

 

[John W. Vinson]

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

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]