Maximum no. of chars in a combobox

[swee]

What is the maximum no. of characters allowed in a combobox?

 

[WayneRyan]

swee,

Dunno ... could be 255 or 65,354 ... but you can't display that many.

What do you need to do?

Wayne

 

[swee]

I entered around 230 words in my combobox and it says that I have entered too many characters. Why is that so?

 

[WayneRyan]

swee,

Why are you entering data INTO a ComboBox?

Combos are supposed to let people SELECT data.

Wayne

 

[swee]

The combobox consists description of all the items in the table. Users are able to add new records to the table through input into the combobox as well. That is why I have to let users fill up comboboxes by typing in. I think the maximum size is 50 chars and that's not a lot.

 

[WayneRyan]

swee,

The real limit is 255, but I still don't understand. You can use a TextBox and
then do a DLookUp, but you can't really expect someone to type in something
that long without a mistake.

Wayne

 

[swee]

swee,

The real limit is 255, but I still don't understand. You can use a TextBox and
then do a DLookUp, but you can't really expect someone to type in something
that long without a mistake.

Wayne

Hi Wayne,

I did not think about the DLookUp method before you mentioned it. Maybe you can take a look at my form and give me your 2 cents worth. If the user types in something that can't be found in the database, there will be a form prompted for them to add the item to the database first.

The form im talking about is SubFrmOrderInfo. Thanks!