Text field in Access database.

I am creating an user interface where the user wants to store some information in a text field.I have to use an access database where the text field cannot be more than 255 characters.Is there any other way to store the information.If not ,how do I restrict the user for not exceeding the limit of 255??When he is esceeding the limit it is causing a run-time error.Please reply.

You could create another Table used to Store Multiple Lines of 255 Character Data, or you could set the MaxLength Property of the Textbox(s) to 255.

------------------
Aaron Young
Analyst Programmer
[email protected]
[email protected]

Set the maxlength property on the form.field to 255, if you want to use a text field. If you want to have the user to have more than 255 characters, use a memo field.

I have changed it to a memo field and my problem is solved.

Thanks for your help!!!!!