Use VBA to open property view for a given control?

[TheSmileyCoder]

Do anyone know how to write a function that would select a control, open the properties for that control, select the correct tab, and set focus to a specific property?

Example:
I call my (at this point imaginary function):
GoToControl("tb_Date","Format")
which should then set focus to tb_date (in design view) and open the properties sheet, and go to the Format Property.

[ADezii]

Selecting a Control, Opening the Properties Window, and selecting a specific Property is the easy part. It appears that accessing a specific Tab is another matter all together since they are dynamic, the Tab that appears at the forefront of the Properties Dialog, apparently is the last Tab that was accessed.

[TheSmileyCoder]

Hi Adezii and thank you for your answer.

How do you open the properties window from VBA and select a property?

Then I can hopefully build from there.

[ADezii]

Me![txtLastName].SetFocus               'Set Focus to the Control
 
DoCmd.RunCommand acCmdProperties        'Open Properties for the Control
 
'Critical Step missing, CTRL+TAB will cycle through the Tabs, but the same
'Tab isn't always in the forefront, Hot Keys to access Tabs won't work, etc.
 
SendKeys "{DOWN 4}", True               'Scroll down to the 5th Property on Tab
                                        '(only method that I am aware of for this)

[TheSmileyCoder]

Thank you for what you have provided so far.

Do you (or anyone else) know of a way to get feedback on what current Tab/property IS selected?

[ADezii]

Do you (or anyone else) know of a way to get feedback on what current Tab/property IS selected?

Sorry, but I do not and that is the $1,000,000 question. It must be controlled internally by Access. What, may I ask, are you trying to accomplish? Perhaps there is an alternative solution to your dilemma.

[TheSmileyCoder]

Im working on a form, where you can enter a word to search for, and it will then search queries, table definitions, modules and forms for that word. That part is working ok, so far, but I wanted to enhance it by making a go-to button, so that when the keyword was found in e.g. a controls rowsource, it could open that form in design view, select the control, and highlight the rowsource.

[ADezii]

Interesting idea, but until you can figure out how to manipulate the Propert Sheet Tabs and associated Properties for a given Control, will be very tough to implement. I'll still scout around for ideas, since this is so interesting. Take care, and if I come up with anything, you'll be the first to know.