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

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

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...
 
Vadimbar said:
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...
Click to expand...
The problem is in the field, What is the field size set to.
What is the length of the data in the combo?
 
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...
 
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.
 
Back
Top