If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with Combo box not displaying all
We have 107,000 addresses in our database. I have a
combo box on the main form to allow staff to bring up the address when they start typing. Problem appears that only 1/2 of list is showing. If they ask for an address in the first half say of the database the address with come up and they can click the dropdown the address will be there and they can select the specific one they want (different unit nos). If they search for an address that is in the bottom half of the database, they can still get the address to come up on the search box but when the click the dropdown the address is not there highlighted for them to pick from. Is there some kind of limitation that I need to be aware of. Thank you for any help. Irene |
#2
|
|||
|
|||
Help with Combo box not displaying all
On Thu, 27 May 2004 14:49:53 -0700, "IreneJ"
wrote: Is there some kind of limitation that I need to be aware of. Yes: a Combo Box is limited to display 65536 records, no more. You may want to have some code to "pre filter" the combo box's Row Source query to be under that limit. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|