field is too small to accept the amount of data you attempted to add

[wshs1]

i keep getting this error message.
its from a combo box which has 2 columns.
i've tried expanding the field size but it's still not working.. i've also tried getting rid of the other column to make it one yet still not working. It only contains about 10-15 words so i have no clue why it's saying the field is too small to accept the amount of the data...
any ideas?

 

[missinglinq]

What are you trying to do with the combobox when you get the error message?

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[kjv1611]

wshs1, it sounds like you are trying to put too much data into a small text field in a table. If it is a lot of data you are entereing for one field in one record, maybe you need to change the size constraits of the field, or change to "memo".

 

[Remou]

Is this a bound combo box? Have you checked the field size of the bound field?

 

[wshs1]

yes, it is a bound combo box. By bound field you mean the field from the table that cbo box is bound to right?
i've tried changing it to 255 and still no luck.
i've tried changing it to memo as well. still same error message.. i've had texts longer than this. first time i've encountered this message..

 

[missinglinq]

That's why I asked what he was trying to do with combobox. It sounds like wshs1 is using the combobox to populate a field that is too small. Although a text field can have up to 255 characters, Access defaults to 50 characters when the table is designed.

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[missinglinq]

field is too small to accept the amount of data you attempted to add

What field are you trying to add data to? I don't think the problem's is with the combox but rather in what you're trying to do with it.

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[wshs1]

nothing.. just a rowsource for users to choose from and trying to bound it to a field..

 

[wshs1]

wth.. it's working now... i just erased the row source and re-typed the bound field and it's working.. how frustrating.. anyways, thank you for your help guys.
really appreciate it!!

 

[kjv1611]

wshs1,

The rowsource has to be linked to a table and field or value list of some sort. What is the rowsource for your form control (textbox)?

Right-click on the textbox, choose properties, data, record source.