Limited field sizes in Access form

[Mejmeyster]

Hi,

I'm trying to modify a pre-existing form so that the text boxes will allow me to store more than 255 characters in them. I've traced back to the table where all the data is stored and tried changing the field type to "memo" instead of "text." When I go to save the table, however, I get the error message saying "Record is too large." What should I do?

Thanks for all your help.

[Killer42]

What version of Access?

[Mejmeyster]

Access 97

Thanks!

[NeoPa]

Do you have records in the table when you try to save?
If so, try backing up the table then trying it on an empty version.

[MMcCarthy]

Hi,

I'm trying to modify a pre-existing form so that the text boxes will allow me to store more than 255 characters in them. I've traced back to the table where all the data is stored and tried changing the field type to "memo" instead of "text." When I go to save the table, however, I get the error message saying "Record is too large." What should I do?

Thanks for all your help.

Try deleting one of the controls and redragging it back on from the field list.

Sometimes it's just not enough to change a field data type the control retains its original settings.

[Mejmeyster]

That worked like a charm. Thanks so much!