Increase data field in ACCESS

[Guest]

How do I increase my data field in Access to more than 255 chars?

 

[Guest]

You can use a Memo field but there are some drawbacks.

You can not sort on a memo field.

What you can do is extract the leftmost 255 characters from the memo field
and sort that.

 

[Joseph Meehan]

How do I increase my data field in Access to more than 255 chars?

Use a memo field.

In my experience there are very few well designed databases with fields
using anything approaching 255 characters.

 

[Joseph Meehan]

How do I increase my data field in Access to more than 255 chars?

I believe I answered this one before, but I never saw my response so
here is a replay.

You can't increase the field size, but you can change it to a memo
field.

I will add that based on my experience, despite what may users will tell
you, it is unusual to find a situation that really calls for more than 255
characters in a field.