Text Box Size

[bilbonvidia]

How do I change a text box so that I can type more than 255 characters? Thank you

 

[deBassMan]

you can't - try a memo field

good luck

 

[missinglinq]

Actually, you can type as many characters as you like in a text box, but in order to store more than 255 you'll need to change the underlying field in your table to a memo field datatype. This will give you approximately 65K characters, but be aware: memo fields are meant to hold memos! Memos are essentially notes, and that's what the memo datatype is designed for. Access queries don't deal kindly with memo fields when you try to do data manipulation with them. If you're going to need to search for data, sort data or do any of the other myriad of things we do with data you need to think twice before going with a memo field. You also need to avoid doing any kind of formatting of data in memo fields. Because I use memo fields a lot, I have a file titled MemoFieldAngst where I've collected problems associated with them:

Crosstab queries, Summary queries, Union queries, and Queries that use Distinct or DistinctRow will all truncate a memo field to 255 characters so Access can perform the required functionality of eliminating duplicates.

Also, if you have specified a format in the field's Format property, this will often truncate the data as well.

If Unique Value Property is set to Yes, Access has to compare the values and therefore Memo Field values are truncated.

Good luck!