Layout for Controls extended.

[Perceptus]

When I am designing a form there is a Layout for items, where Labels and Text boxes are Paired together. Can I access this layout collection in vba?



I would like to know what the associated label for any related control is.

Thank you for your time

[June7]

Bing: vba microsoft access textbox associated label

http://stackoverflow.com/questions/1...ontrol-in-code

[Perceptus]

What, a useful search using Bing? Hogwash!

Thank you June, will check right now.

[Micron]

Perceptus; you used the words "paired together". Perhaps you meant where the label is "attached" to the control, which is the correct term. Not that I'm nit picking on your terminology - I just want to point out that the solution only works for attached labels.

[June7]

No, let's nit pick - the correct term is Associated.

[Micron]

Well, as long as you're in the mood, I quoted MVP's first, but saved the best for last...

Allen Browne: If there is an attached label, it will be the first member of the Controls collection of our control...

Dirk Goldgar: Normally, if a control has an attached label, hiding the control will make the label invisibile...

Microsoft Office:
https://support.office.com/en-za/art...479f8e6e3c35#a
compound control
A control and an attached label, such as a text box with an attached label.

Perhaps we can agree that the correct term is not "paired together".
I also concede that "associated" is widely used and is acceptable.

[June7]

And if you accept that Access is the horse's mouth - create a label control in Detail section and it shows the warning "New Unassociated Label" and offers the option to "Associate Label with a Control".

Paired, Attached, Associated - a rose is still a rose - the intended meaning with all three is that the two controls are joined at the hip.

Let's say they are all correct

[Micron]

I have already agreed that associated is a common term which imparts the same meaning. Since we're nit-picking according to your post #5, what about option buttons that are associated with a frame? The option chosen from the option group is passed to the associate (frame) but if you move the frame, it does not move the option buttons - because they are not attached. Maybe that was meant to be the deciding factor. I would not even attempt to understand why the terminology is mixed within the bubble help of the program as it is not important to me. If they are all the same as you state, perhaps there was no need to call me out on it?

[Perceptus]

June nailed it on the head with that link. Thanks again June.

[June7]

Just trying some friendly banter. Sorry if you took it as harsh.

[Perceptus]

No harm no foul =). I'm really bad on my terminology.

[June7]

Perceptus, my last post was intended for Micron. Guess I should have indicated that.