Move a form control to the back upon creation with vba

[Tegglet]

I have created two superimposed controls and wish to explicitly set which one is on top using VBA code. Is this possible? The visible property is set to True or False according to the result of an "If" statement.

I can find nothing on the web which makes me wonder if this can only be done from the "Arrange Tab" > "Sizing and Ordering" items on the ribbon.

[Welshgasman]

Have you looked at the Position options?

That would then give a clue as what to search for?

One link found. https://stackoverflow.com/questions/...r-send-to-back

Plus you just hide/show each as required.

[Micron]

AFAIC the question relates to z order for controls, and I think there is no such thing in Access vba I but could be wrong.
What's wrong with hiding one or the other? Doesn't that make it appear that there is only one? Perhaps you only need one anyway, especially if the are the same type. Its properties and function could be altered based on whatever your If test is all about.

[Tegglet]

Have you looked at the Position options?

That would then give a clue as what to search for?

One link found. https://stackoverflow.com/questions/...r-send-to-back

Plus you just hide/show each as required.

I was looking under the "Sizing and Ordering" options (see first post) and searching accordingly but could find nothing. The code from the link wouldn't work either at creation time or when the form was opened.

Micron

AFAIC the question relates to z order for controls, and I think there is no such thing in Access vba I but could be wrong.
What's wrong with hiding one or the other? Doesn't that make it appear that there is only one? Perhaps you only need one anyway, especially if the are the same type. Its properties and function could be altered based on whatever your If test is all about.

This was a belt and braces thing, I have created the combo box before the list box which puts them in the order I want. I just wanted to be sure that future changes didn't upset the apple cart.
I am using the visible property to display/hide it as required. This works fine with the code as it is, I was just trying to make it a bit more robust.


Thank you both for your prompt responses.

[Tegglet]

QUOTE=Welshgasman;527806]Have you looked at the Position options?


That would then give a clue as what to search for?


One link found. https://stackoverflow.com/questions/...r-send-to-back


Plus you just hide/show each as required.[/QUOTE]


I was looking under the "Sizing and Ordering" options (see first post) and searching accordingly but could find nothing. The code from the link wouldn't work either at creation time or when the form was opened.

Micron AFAIC the question relates to z order for controls, and I think there is no such thing in Access vba I but could be wrong.
What's wrong with hiding one or the other? Doesn't that make it appear that there is only one? Perhaps you only need one anyway, especially if the are the same type. Its properties and function could be altered based on whatever your If test is all about.

This was a belt and braces thing, I have created the combo box before the list box which puts them in the order I want. I just wanted to be sure that future changes didn't upset the apple cart.
I am using the visible property to display/hide it as required. This works fine with the code as it is, I was just trying to make it a bit more robust.



Thank you both for your prompt responses

[pbaldy]

Posts 4 and 5 were moderated, I'm posting to trigger email notifications.