Access: field length limitation

[Kathy]

Access for Office 97 limits the maximum length of a field
to 250 characters. Does anyone know if it is possible to
create a larger field??

HELP! Thanks

 

[Terry]

Access for Office 97 limits the maximum length of a field

to 250 characters. Does anyone know if it is possible to
create a larger field??

HELP! Thanks

The maximum length of a text field in Office XP is 255 characters. You could
use the Memo datatype instead which stores up to 65,535 characters. If that
isn't enough space there appears to be another way to manipulate the Memo
field, but that's beyond my experience. I think the same applies to A97, but
I'm sure an MVP will put you right if that isn't the case.

Hope that helps
Terry

 

[TC]

If there was a limit of 250 (actually 255), and there was some way you could
break that limit, how would the 250/255 have been "a limit"?

TC

 

[Cheryl Fischer]

No, you cannot have a text field larger than 255 characters; however, you
can use a Memo field which will accept some 65K characters.