populating text box based upon list box selection

[SoxPats83]

i have a list box with a command button next to it for the purpose of "Add". the user will make selections in the list box (single or multiple) and then click on the command button to add them to another text box. i have accomplished this. i can add upto two selections at a time. anymore and i get "error 3163: the field is too small to accept the amount of data you attempted to add. try inserting or pasting less data". the problem is pretty self explanatory and when i open the text box's properties the only thing that i can see that would possibly help is the "Can Grow" option which is default to no. i have changed it to yes and this still does not make a difference.

anyone have any ideas?

 

[rainman89]

Are you trying to insert something larger than 256 chars? Which is the Max size for a text field?

 

[SoxPats83]

Are you trying to insert something larger than 256 chars? Which is the Max size for a text field?

ugh, i knew it would be something obvious. thank you!

 

[rainman89]

ugh, i knew it would be something obvious. thank you!

Its ok. I understand. Probably because you are a Sox fan!! <----Yanks here!

 

[missinglinq]

Are you trying to insert something larger than 256 chars? Which is the Max size for a text field?

The Sox fan doesn't have to be trying to populate the field with over 256 characters, he only has to be trying to populate it with more characters than the field's size is set to in the Table, where the Default is a mere 50 characters.

And yes, you have to make certain allowances for anyone who is handicapped by being a Sox fan! Just bought my 25th Yankees cap! Got my first one, along with an Enos Slaughter model glove, in 1956!

 

[rainman89]

The Sox fan doesn't have to be trying to populate the field with over 256 characters, he only has to be trying to populate it with more characters than the field's size is set to in the Table, where the Default is a mere 50 characters.

And yes, you have to make certain allowances for anyone who is handicapped by being a Sox fan! Just bought my 25th Yankees cap! Got my first one, along with an Enos Slaughter model glove, in 1956!

Thanks Linq. I was close!

And wow!! Long time ago!

My gf's family is all sox fans so we have a good rivalry going there.. Bought a red sox shirt just so I could spray paint sucks on it!

 

[boblarson]

where the Default is a mere 50 characters.

Linq -

Just an FYI for you - the DEFAULTS can be changed (in 2007 the "out of the box" default for text is 255 where the "out of the box" default in 2003 and earlier is 50 for text).


To set different default sizes you can go to TOOLS > OPTIONS > TABLES/QUERIES and change the defaults for TEXT and NUMBER.