Combo box gives '3077' error only on certain records

[mbs4653]

Hello,

I have an Access 97 form that uses a combo box to fill in the rest o
the controls on the form. It is based on a query and the query show
all the records, which are checks. However, the form's combo box onl
shows checks up to 9001147979, and does not see the records with chec
numbers (text field) that are greater than that. i.e. Though the quer
shows check #998, the combo box does not. It just gives the 3077 erro

 

[mbs4653]

Think I have found the problem....Access combo boxes allow for a maximu
of 65535 records, and the combo box I am working on uses a query tha
returns 66314 record