How can I increase character length in my text boxes?

[Guest]

I have finished my database in access and now that I have come to input I
have found that certain text boxes do not have enough room for more than a
certain number of characters. How do I go about changing this?

 

[Guest]

Go back into the table design and change the length in the bottom pane.

 

[John W. Vinson]

I have finished my database in access and now that I have come to input I
have found that certain text boxes do not have enough room for more than a
certain number of characters. How do I go about changing this?

Open the Table in design view and view the properties of this field. If you
can get by with 255 characters, just leave it as Text as the datatype and put
255 in the size field (Access doesn't store trailing blanks so this won't hurt
if you usually have fewer).

If you need more than 255 characters, change the datatype from Text to Memo.
That will give you 65536 characters (or over a billion if you load the data
programmatically).

John W. Vinson [MVP]

 

[Guest]

Many thanks!

Open the Table in design view and view the properties of this field. If you
can get by with 255 characters, just leave it as Text as the datatype and put
255 in the size field (Access doesn't store trailing blanks so this won't hurt
if you usually have fewer).

If you need more than 255 characters, change the datatype from Text to Memo.
That will give you 65536 characters (or over a billion if you load the data
programmatically).

John W. Vinson [MVP]