Column Count Limits

You probably know that a combo box or a list box can have multiple columns. In fact, the control will display all of the fields in the bound table or query from left to right up to the number you specify as the control's Column Count property. In other words, if the bound object has ten columns and you set the control's Column Count property to 8, the control will display the first eight columns from left to right.

There is one catch that you might not be aware of--the Column Count property value must be an integer 1 through 255. Neither the combo box nor the list box can display more than 255 columns. However, this limitation shouldn't cause too much trouble, since 255 columns will be more than adequate for most uses.

Access Index

Main Index