Access Properties sort/search
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.)
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.)
ASKER
Thanks Mark
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.
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.
ASKER