combo box not displaying ALL records

[leebop]

Can anyone tell me why my combo box does not display all the reords from the record source???

The box is bound.

The are 207 records in th source, but it only shows to record 98. If however i type the first letter of a record, it will let me select this record, although it is not in the list.

Advice appreciated,
Lee

 

[dcx693]

What is recordsource of the combo box? If you set the combo box to select existing values in the same field, then you will only be able to pick values that already are entered into that bound field.

 

[WayneRyan]

leebop,

Haven't seen this before, but you might try Tools --> Utilities
and look at the Edit/Find tab. One of the entries says
"Don't display lists where more than this records read".

Change that number.

Wayne