Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text boxes cant hold enough!!

Status
Not open for further replies.
Toby1kenobe

Toby1kenobe

Instructor
May 26, 2002
66
GB
Can i increase the capacity that a textbox can hold? I am right saying that they can only hold 255 characters?

Thanks for any help
Toby
 
Sort by date Sort by votes
Toby: Yepper, that's the max. Change it to a Memo field and your good to go.
 
Upvote 0 Downvote
Just remember that if you go to memo fields, you can't groub by or query. So your data is not really as valuable anymore.
 
Upvote 0 Downvote
There are some limitations to querying memo fields, you can work around some of this. How about this. Use 2 text fields and in the end (report, form) concatenate the two.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
"There isn't enough memory to perform this operation..." error after upgrading from Access
Replies
2
Views
434
Axworthy
Axworthy
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
290
caykamanj1966
caykamanj1966
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
655
PrimoSteve
PrimoSteve
nikademous
  • Locked
  • Question
Fill text boxes with table data 1
Replies
12
Views
426
dhookom
dhookom
nikademous
  • Locked
  • Question
Expand text box width to fit text 1
Replies
17
Views
1K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top