How can I increase character length in my text boxes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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]
 
Many thanks!

John W. Vinson said:
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]
Click to expand...
 
Back
Top