Label/Texbox separation in Microsoft Access 2007 forms

Question

I'm trying to create a very simple form in an Access database. Whenever I drag a textbox on the form, a label gets created with it. I want to be able to move the label without moving the textbox,but whenever I try to do that, the textbox moves with it. Its like they're linked with each other. Is there a way to separate them from each other so that they can be moved separately?

Aprilette

Answer 1

Yes, but you are better off looking for the small square black box that appears on the top left corner of each control when you click the textbox or label. This box will allow you to drag each control independently. Don't forget Format->Align (Left,Right,Top,Bottom) it is probably more useful for tidying up controls than anything else.

You can separate the label from its parent control by deleting the label, clicking the detail section to ensure that no controls are selected, and pasting, but I would advise against it. You can do a number of useful things with labels that are related to controls and one of them is move the two together - this is useful when you have the form tidied. Another is to find the parent of the control, which is useful when using VBA to change controls.

Spherics

Answer 2

While in design mode, With the label and field selected, click the Arrange button located on your ribbon toolbar along the top, you will see a button in the control layout section of the Arrange group. Select the remove button. This will remove the connection between the label and the field.

Disobedience

Answer 3

You can also use Group/Ungroup menu commands to establish/remove the connection. Grouping the label and control causes them to move together in design view.

Wildfowl