Access 2007 Bound Controls on Forms in design view

[WerdanNJ]

I must be missing something. I'm trying to create a form with checkboxes and labels. I don't know what happened but now when I try to add a new checkbox control, the label box is now before the checkbox when before it was after. How does one set/move/change this behavior?? I cannot find this anywhere on MS website or even in my Access 2007 for dummies book.

[puppydogbuddy]

I must be missing something. I'm trying to create a form with checkboxes and labels. I don't know what happened but now when I try to add a new checkbox control, the label box is now before the checkbox when before it was after. How does one set/move/change this behavior?? I cannot find this anywhere on MS website or even in my Access 2007 for dummies book.

See the tip below from the tip page of www.aadconsulting.com . The tip shows you how to change the default position of labels for each control type. If you just want to change the position of the label that "shifted", you can bypass the step of going to the toolbar and just change the label's x and y position for that control specifically.

Change the Default Position of Attached Labels

Access attaches a label to the left of a control by default.

To change the default position of a control's attached label you can set the left and top co-ordinates of the label using the control's Label X and Label Y properties. For example, to change the default so that the label appears to the right of a text box:

In Design view, double-click the form's Properties button to open the form's Properties window. In the Toolbox, click the Text Box button, to display the default Text Box properties in the Properties window. On the Format tab, change the default from -1 to 1in (or -3 to 3cm) for the Label X property.

You can also change the default position of the attached label so it is located above the text box, by setting the Label X property to 0 and the Label Y property to -0.25in (or -0.75cm).

[WerdanNJ]

See the tip below from the tip page of www.aadconsulting.com . The tip shows you how to change the default position of labels for each control type. If you just want to change the position of the label that "shifted", you can bypass the step of going to the toolbar and just change the label's x and y position for that control specifically.

Change the Default Position of Attached Labels

Access attaches a label to the left of a control by default.

To change the default position of a control's attached label you can set the left and top co-ordinates of the label using the control's Label X and Label Y properties. For example, to change the default so that the label appears to the right of a text box:

In Design view, double-click the form's Properties button to open the form's Properties window. In the Toolbox, click the Text Box button, to display the default Text Box properties in the Properties window. On the Format tab, change the default from -1 to 1in (or -3 to 3cm) for the Label X property.

You can also change the default position of the attached label so it is located above the text box, by setting the Label X property to 0 and the Label Y property to -0.25in (or -0.75cm).

Thanks and I saw and know this, what I'm saying is that I already have controls on the form and want to change them. When I click on them to see their properties, I do not see the Label X and Label Y choices to change them. However, when I select the Form Property Sheet I see these choices but its only when I create new controls on the form. I guess I'll have to delete all the current controls on the form and recreate them. <grrr>

Thanks for the reply

[puppydogbuddy]

Thanks and I saw and know this, what I'm saying is that I already have controls on the form and want to change them. When I click on them to see their properties, I do not see the Label X and Label Y choices to change them. However, when I select the Form Property Sheet I see these choices but its only when I create new controls on the form. I guess I'll have to delete all the current controls on the form and recreate them. <grrr>

Thanks for the reply

Sorry to confuse you. The left and top properties determine the horizontal and vertical positions. I believe the Label X and Label Y in the tip refer to the name property of your labels. So all you really need to do is hightlight all the labels you want to have the same horizontal and/or vertical position, change the property, and then save.

[WerdanNJ]

Sorry to confuse you. The left and top properties determine the horizontal and vertical positions. I believe the Label X and Label Y in the tip refer to the name property of your labels. So all you really need to do is hightlight all the labels you want to have the same horizontal and/or vertical position, change the property, and then save.

Thanks. Got it now. I can set the defaults by selecting the form and then the control. Then on existing controls I have to sort of ungroup them by selecting "remove" on the control layout section of the "Arrange" tab of the ribbon. Then I can change the Top and Left settings of the label and it will not move the checkbox along with the label box. It was this step that I didn't do before and when I changed the top and left settings of the label box it was still moving the check box along with it and not putting the label box after the check box.

Thanks for the help.

[puppydogbuddy]

Thanks. Got it now. I can set the defaults by selecting the form and then the control. Then on existing controls I have to sort of ungroup them by selecting "remove" on the control layout section of the "Arrange" tab of the ribbon. Then I can change the Top and Left settings of the label and it will not move the checkbox along with the label box. It was this step that I didn't do before and when I changed the top and left settings of the label box it was still moving the check box along with it and not putting the label box after the check box.

Thanks for the help.

You are welcome. Glad you got it resolved. I never have the problem with the control and label moving together because I always make sure that I only click on the label, itself, using the Shift Key + mouse click. Thanks for the feedback information.