The Field is too small to accept the amount of data you attempted

[Guest]

The Field is too small to accept the amount of data you attempted to add. Try
inserting or pasting less data.

My table has two fields. I am only working with the first field. Its a text
filed and it has less then 60 chcracters. Its fine in table mode but when I
create a form an try to pull this data from a combo box I get the error
above. Is there a way to increase the text size on a combo box?
Thank you,
VADIMBAR...

 

[Mike Painter]

The Field is too small to accept the amount of data you attempted to
add. Try inserting or pasting less data.

My table has two fields. I am only working with the first field. Its
a text filed and it has less then 60 chcracters. Its fine in table
mode but when I create a form an try to pull this data from a combo
box I get the error above. Is there a way to increase the text size
on a combo box?
Thank you,
VADIMBAR...

The problem is in the field, What is the field size set to.
What is the length of the data in the combo?

 

[Guest]

Mike thank you. I guess i was working on this a little too late for normal
people. Because I have two tables I had the original set to 255 characters,.
The table I was popuklating was set to 50. That was the problem. Thank you
and I'm sorry for the silly question.
Vadimbar...

 

[Guest]

It's not a silly question. I was having the same problem, and it was driving
me crazy.

Yes, increasing the size of the table field did work. What I don't
understand is, why I have to increase the field size from 50 to 75 (just
arbitrary trial and error) to accept a 25 character hyperlink. In one record,
a field size of 50 would hold 19 characters, but not 21. A field size of 75
seems to handle anything I need to use.