narrow search as you type

[Jason Lewis]

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.

[Larry Linson]

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***@NOdickso nSPAM.st> wrote in message
news:3f******** *************** @news.swiftel.c om.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.

[Jason Lewis]

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***@NOdickso nSPAM.st> wrote in message
news:3f******** *************** @news.swiftel.c om.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.