how to change text field size from 20 to 26

[Azariah]

I have a text field in a table that is defined as 20 characters long. I want to increase the size to 26, but I keep getting a 'record too big' error. I only have 125 fields in the entire table. I changed the field type to memo, but it still won't let me save the updated table. It seems so simple, what do I need to do now?

[June7]

No idea. Never had an issue with changing text length. 125 fields is actually a lot.

If you want to provide db for analysis, follow instructions at bottom of my post.

[ranman256]

Make a new field. save.
run an update query to copy the old field to the new one.
then delete the old one.

[orange]

Tell us more about
-your database (what is the subject matter ---overview)
-your table ---It is very rare to see a normalized table with 125 fields.

My guess is that you have a basic design problem, but we know nothing of your business.

[JamesDeckert]

You don't have a front end, back end do you? You can't change the back end design from the front end. Your error doesn't sound like this is the problem, but sometimes errors are weird.