Moving Textboxes and Associated Form Labels in Microsoft Access

Moving Text Boxes Associated with Form Labels in Microsoft Access

In Microsoft Access, it is common to use text boxes and labels in forms to allow users to input and view data. However, sometimes you may want to move text boxes around in the form, but find that the associated label also moves. This can be frustrating, especially when you want to bring two text boxes together without moving the labels. In this article, we will explore how to remove the layout text boxes form, allowing you to move text boxes independently of their labels.

The Problem with Moving Text Boxes and Labels

When you add a text box and a label to a form in Microsoft Access, they are automatically grouped together as a layout object. This means that when you move one object, the other object moves with it. While this can be useful in some cases, it can also be limiting. For example, if you want to bring two text boxes together, but keep their labels in place, you may find it difficult to do so.

Removing the Layout Text Box Form

To remove the layout text box form and move text boxes independently of their labels, follow these steps:

1. Open the form in Design view.
2. Select the text box and label that you want to move.
3. Right-click on the selection and choose Format Control.
4. In the Format Control dialog box, uncheck the Move and size with cells option.
5. Repeat steps 3 and 4 for all the text boxes and labels that you want to move independently.

Once you have unchecked the Move and size with cells option for each text box and label, you can move them independently of each other. This will allow you to bring two text boxes together without moving the labels.

Code Example

Here is an example of how to remove the layout text box form using VBA code:

This code loops through all the controls on the form and sets the Move and size with cells property to False for each label and text box. This has the same effect as unchecking the option manually.

In this article, we have covered how to remove the layout text box form in Microsoft Access, allowing you to move text boxes independently of their labels. By following the steps outlined above, you can bring two text boxes together without moving the labels, giving you more control over the layout of your form.

References

• Control the layout of a form or report in Access
• How to move a text box without moving its label
• Moving text boxes independently of labels