Access Properties sort/search

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

In Access the properties of for example a ListBox have so many items that it is not quick to pinpoint what I am looking for. Is there a way to sort properties or search a specific property?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Analyst Assistant
Commented:
You could use the Object Browser (F2).

Then there's Intellisense which will show all the properties of a control in an alphabetically sorted dropsown if you type a . after it's name as you are writing your code.
John TsioumprisSoftware & Systems Engineer
Commented:
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
By default, they are sorted topic-wise which, in most cases, is the fastest method to pin down what you are after.
However, at top-right of the property sheet you can click the A-Z button to have them sorted alphabetically if you prefer.
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
thanks very much for the advice
Mark EdwardsChief Technology Officer

Commented:
Intellisense is a great feature, but it only works if the rest of your code (not the line you are working on) compiles (in most cases).
TIP:  Wouldn't you like to see your "Private" procedures appear in the intellisense list of public procedures and variables when you type "Me."?  In case you don't know about it yet, there is a procedure scope you can use in forms/reports called "Friend" that allows the name of the procedure to appear in the list of procedures and variables if you type "Me.", but doesn't expose it outside the form/report (instead of "Public", which makes the procedure visible outside the form/report, or "Private", which doesn't expose it to intellisense.)
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thanks Mark
Mark EdwardsChief Technology Officer

Commented:
Also, you can get an intellisense list of your public module procedures by typing the name of the module then a period (i.e. "basModule1.") to bring up a list of public procedures in your module.  Also, while it is NOT advisable to have public module procedure names with the same name, putting the name of the module in front of it prevents the compile error you normally get in that case.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
However, at top-right of the property sheet you can click the A-Z button to have them sorted alphabetically if you prefer.

 Note that this is only in Access 2016 and up.

Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial