How do I increase the field size to 400 in a database table?

[Guest]

Can anyone help? I need to get more characters than 255 into some fields in a
table

 

[Allen Browne]

Open the table in design view.
Select the field.
Change it to a Memo type instead of a Text type.

 

[Guest]

Just remember that you can not sort on a memo field in older versions of
Access.

A work-around is to pull 255 charaters and sort like this --
ORDER BY Left([YourMemo], 255)

 

[Guest]

Thanks Allen. It worked a treat

Daniel

Open the table in design view.
Select the field.
Change it to a Memo type instead of a Text type.