Results 1 to 3 of 3
Thread: Limit on Combo Box columns ?
2014-03-15, 21:14 #1
- Join Date
- Jan 2004
- Thanked 111 Times in 96 Posts
Limit on Combo Box columns ?
I'm using Access 2003 and resurrecting my ancient skills on a simple database.
I have a simple table and a query with 11 columns. I am selecting the key field with a Combo Box which picks up all the remaining columns from the query, then displays some of the results in text boxes. That's all fine except that I only seem to be able to pick up the first 8 columns, then the text boxes don't show anything when pointed at the relevant columns eg =Combo0.Column(9)
Am I doing something wrong, or have I hit an Access limitation ? Either way, is there a better (simple) way of doing this ?
Last edited by MartinM; 2014-03-15 at 21:25.
2014-03-17, 10:55 #2
- Join Date
- Aug 2001
- Evergreen, CO, USA
- Thanked 64 Times in 63 Posts
In general combo boxes aren't used to that many columns, simply because you run out of horizontal space when all of them are displayed. So I presume you are hiding some or most of the columns. The first column in a combo box is referred to as Column(0), so Column(8) would actually be the 9th column. But I'm not aware of any limitation on the column number like you are apparently seeing.
As an alternate way of doing what I presume you are doing, you bind the form that contains the combo box to the query you are using, and then use the combo box to select a specific record in the query, either with a filter or using a recordset approach. The latter is how the combo box wizard selects a specific record in a table, and in that case the combo box is unbound, and uses a small VBA procedure to display a specific record on the form.Wendell
2014-03-27, 10:01 #3
- Join Date
- Mar 2013
- Thanked 1 Time in 1 Post
Check the property sheet
Make sure you have defined 11 columns on the combo box property sheet. If you have defined fewer than 11, Access and the combo box will not see all of the query columns and you cannot address them. In your example, not being able to address Column(9) suggests that the number of defined columns in the combo box is less than 10.
I'm guessing the actual limit is 255, but no one would ever go there, would they? <smile> The most I've ever used is in the neighborhood of 10.