View Full Version : Can Grow On Combo List


CanWest
10-20-2010, 11:46 PM
I have a control on report that gets it's data from a lookup table. There does not seem to be a Can Grow property on a combo box (Access 2003). I need this to be able to grow. Is there any way to do this.

Magster
10-25-2010, 03:28 PM
Usually combo boxes are based on queries and in order to "make a combo box grow" it would be to requery it and if any new rows are there, they would be retrieved by the query. So, the combo box in essence would grow - actually it would contain more rows.

I've never used a lookup table with it, but maybe it would have the same capability.

boblarson
10-25-2010, 03:34 PM
What exactly do you need to grow? A combo will list as many entries as it has (it has capacity of up to about 65,000 rows). You can display more than the default 8 at a time by setting the ListRows property and you can display wider view of the visible selections width-wise by modifying the ListWidth property.

WayneRyan
10-25-2010, 05:58 PM
A sub-report can display the contents of the LookUp table and it will be able
to use the "CanGrow" & "CanShrink" features.

hth,
Wayne