By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,336 Members | 2,315 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,336 IT Pros & Developers. It's quick & easy.

Limited field sizes in Access form

P: 6
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.
Oct 30 '06 #1
Share this Question
Share on Google+
5 Replies


Expert 5K+
P: 8,434
What version of Access?
Oct 30 '06 #2

P: 6
Access 97

Thanks!
Oct 30 '06 #3

NeoPa
Expert Mod 15k+
P: 31,494
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.
Oct 30 '06 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Oct 30 '06 #5

P: 6
That worked like a charm. Thanks so much!
Oct 31 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.