How do I change a text box to have unlimited text?

[Guest]

I have a form that someone else created that contains a text box. The
current text box only allows a limited amount of text in it. I need it to
have unlimited text. Can someone tell me how to change the text box for that?

Thank You!

Lauren

 

[Rick Brandt]

I have a form that someone else created that contains a text box. The
current text box only allows a limited amount of text in it. I need it to
have unlimited text. Can someone tell me how to change the text box for that?

You don't change the TextBox. You change the DataType of the field in the table
that the control is bound to (to Memo).

 

[Guest]

It is probably the field to which the text box is bound. If the field's data
type is Text, then there will be a specific character limit specified in the
table design view (maximum of 255 characters). You can change it to Memo,
which, while not exactly unlimited, does increase the limit to 65,535
characters.