Search box: possible to limit searchable fields?

Thirith

Board Regular
Joined
Jun 9, 2009
Messages
118
Is it possible to define/limit the fields that are actually checked when you use the search box, to speed up matters? I've done a quick Google search on this and haven't found anything. For the database I'm working on, there are 3-5 fields (out of ~20-25 in total) that are relevant for searches, so might be handy if the search box only looked in those.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
My recollection of using search with access was that you could search "whole table" or "within a field". But not within 3-5 fields. I haven't used versions of Access since 2007 for day to day work though.
 
Upvote 0
Not within the 'Find' command on the ribbon.... if this is something you do often then I would recommend using a query to do the search - limiting the criteria to only look in those fields.
 
Last edited:
Upvote 0
Thanks for your replies. I'll think about whether a query searching specific fields only is worth doing under these circumstances.
 
Upvote 0

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top