Combo box issue - Is there a limit on rows in Excel 2003?

[Six Lombardi's]

Using Excel 2003 and I'm a total n00b with it. I'm a database snob
and so Excel is NOT a database, but my employer wants it so he gets
it...

Anyway, I created a combo box and linked it to a named field.
Depending on the value of Cell A:3, the combo box runs a query and
fills the named field with values. This all works fine and dandy.

The problem is; the combo will not show more than 356 records. It
will show the entire dataset if it's less than 356 records, but if the
dataset is longer then it just stops at 356.

Is this a built-in feature of Excel? Is there a switch or property to
look at which tells a combo how many values to hold? Any help is
greatly appreciated.

 

[Jim Cone]

I placed both a Combo box ActiveX control and a Combo box from the Forms tool bar on an
Excel sheet.
Both would accept more than 356 entries.
I suspect your query code or your named field may be restricting the number of entries.
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Formats & Styles lists or removes unused styles or number formats - in the free folder)




"Six Lombardi's" <[email protected]>
wrote in message
news:678763a4-fef6-4a08-bb15-b4a8955bca16@fm22g2000vbb.googlegroups.com...