May 25 2006, 04:02 PM
Hi there. I am making a "notes" type of text box and wanted to know if there is any way to increase the amount of characters in a text box. The maximum that I can set is to 255. I need about 100x that for data entry purposes. Please advise! Thanks~
May 25 2006, 04:08 PM
I am assuming the textbox is bound to a database field. Text type fields can only be up to 255 characters. To get more, change the field to Memo type.
May 25 2006, 04:15 PM
Create a Field with Memo as it data type in your table.
Create a Text Box in your form and link the Memo field to the Text Box in the Control Source
May 25 2006, 05:10 PM
If you are needing that much extra space, I would recommend that you consider using a "notes" child table which will allow multiple entries.It still can use a memo field for a large note. This also will allow you to easily put a data and/or time stamp on each note record as they are added. I have found this is a much better approach than a single note field.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here