Text boxes behind a sub form

[mattP]

I wonder if anyone could help me here:

I have my main form that has a row of buttons at the top, some of these buttons have multiple functions so I have some hidden text boxes underneath that appear on the mouse move command, giving the impression of a drop down list for that button.

Just underneath the buttons I have a subform, the problem I have is that the text boxes will not show on top of the subform, they always appear behind it, is there anyway to get them to show on top of the subform ?

I hope this makes sense.

Regards

MattP

 

[RuralGuy]

Can you use a combination of Format>BringToFront and Format>SendToBack on both the TextBoxes and the SubFormControl to achieve the look you desire?

 

[mattP]

Thanks for the suggestion and I'll try this, however, do I use this in the VBA code and if so how do I use the "Format" command, everything I've tried to enter seems to be assuming I'm formatting a date function ?

Thanks

MattP

 

[RuralGuy]

Hi Matt,

No VBA involved. With the form in design mode, select the SubFormControl and then go up to Format>SendToBack. Then select a TextBox and go up to Format>BringToFront. etc.

See if some combination will achieve the look you want.

 

[mattP]

Thanks for the quick response, I see what you are saying now but cannot get that to work, Subform is always over the top of the label ?

I'm playing with a menu sample I've found, if I get that working I'll post the sample as it is a very simple menu drop down but looks rather nice.

Thanks for all your advise though.

MattP