By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,829 Members | 673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,829 IT Pros & Developers. It's quick & easy.

narrow search as you type

P: n/a
Hi,

I'd like to find a way of narrowing a search, as you type in a field. Kind of
like when you have a big list, as you type, it narrows down the items in the
list to things that match what you have typed. Can anyone point me in the
right direction or give me a link that has an example of how to do it?

Thanks,

Jason

ps. please remove NO SPAM to email me.

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
That's exactly what a Combo Box does by default, so a Combo Box should do
what you want. You'd have to manually reset the AutoExpand property to False
to keep it from doing what you describe.

Larry Linson
Microsoft Access MVP

"Jason Lewis" <ja***@NOdicksonSPAM.st> wrote in message
news:3f***********************@news.swiftel.com.au ...
Hi,

I'd like to find a way of narrowing a search, as you type in a field. Kind of like when you have a big list, as you type, it narrows down the items in the list to things that match what you have typed. Can anyone point me in the
right direction or give me a link that has an example of how to do it?

Thanks,

Jason

ps. please remove NO SPAM to email me.

Nov 12 '05 #2

P: n/a
Hi Larry,

Thanks for your suggestion. I don't think I was quite clear enough though.

I want the search to span multiple fields... ie, i have a product number and a
product description, I'd like to narrow the search as I type each character.

That may not be practical though, as there are many records in the database
(maybe 2000) so I was thinking, even if i could type a few characters, and
press return, and have a list of matching records returned, that would be
good. and then allow the user to type a few more characters to narow further
maybe.

Thanks anyway,

Jason

Larry Linson wrote:
That's exactly what a Combo Box does by default, so a Combo Box should do
what you want. You'd have to manually reset the AutoExpand property to False
to keep it from doing what you describe.

Larry Linson
Microsoft Access MVP

"Jason Lewis" <ja***@NOdicksonSPAM.st> wrote in message
news:3f***********************@news.swiftel.com.au ...
Hi,

I'd like to find a way of narrowing a search, as you type in a field. Kind


of
like when you have a big list, as you type, it narrows down the items in


the
list to things that match what you have typed. Can anyone point me in the
right direction or give me a link that has an example of how to do it?

Thanks,

Jason

ps. please remove NO SPAM to email me.



Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.