Access Checkboxes choosing their own alignment

[Alan K]

Writing an Access database which I am using Checkboxes to create certain options.
What I encountered is Most of the checkboxes align the same... except for 1 of them.

Check Box 1 [ ]
Check Box 2 [ ]
Check Box 3 [ ]
[ ] Check Box 4

The checkboxes are in different locations on my form for specific aspects of the form.

Just can't figure a work around for this. I tried dragging the text aka Check Box label to make it look as I wish. This logic created an error stating "Check Box" was invalid / unknown. I'm guessing from pulling the original Access structure out-of-Whack.

All Checkboxes have the same properties. If you right-click in design view and compare All Checkbox values against another.
I even deleted the field that displays backwards from the Table and retyped the field. Thinking something hidden throwing it off. NOPE.

Has anyone experienced this?
Thanks in advance.

Alan

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[The_Doc_Man]

First, Alan, I'm going to move your question to the the FORMS section because I think that is where it belongs.

 

[MajP]

Can you take a screen shot so we know exactly what you are talking?

 

[The_Doc_Man]

The problem with checkboxes is that they are sensitive little beasts. You should be able to go into design mode and select the check-box without selecting its label (or vice versa), then drag it around a bit to where you want it. However, you should also look at the properties of the checkboxes to assure they all have the same .HEIGHT and .WIDTH and that their .LEFT is also aligned correctly. I'm not sure why you have that reversal of box vs. label, but it should be easy to correct manually.

The question is, from where did you create that misbehaving checkbox? Did you use the same design-mode tools as used by the other three boxes, or was this a box that you copied from another source via cut/paste techniques?

 

[Alan K]

Can you take a screen shot so we know exactly what you are talking?

Unfortunately, I am home now, the project I am doing is at work. Can try and get 1 tomorrow.

 

[MajP]

From what you are showing it just appears the label is on the wrong side. If that is what you mean.
I would delete checkbox four and copy and paste checkbox 3. Modify the label of the newly pasted checkbox, change the control source of the new checkbox, and rename it appropriately.

 

[MajP]

If I misinterpreted, maybe you are talking about an anchoring issue.. If you mistakenly anchor a control in an unexpected way you will lose your mind trying to figure out what is happening. It will appear in a spot not necessarily where you placed it on the form. Imagine you always want a close button in the upper right corner as far to the right as visible. you can place that button almost anywhere of the form and anchor upper right. When the form renders it will move to upper right corner.

 

[MajP]

One more possibility. If you simply want to move the checkbox to the other side of the label I find it much easier to move it this way.
Click on the box and not the label
Ensure you get the cross symbol and hold down
You should now be able to move the checkbox without moving the label.
Position the checkbox on the other side of the label

 

[The_Doc_Man]

There is another possibility having to do with "Layout." Check that you don't have Layout mode turned on when building forms because that has been known to do all sorts of things to control placement.

 

[Alan K]

The problem with checkboxes is that they are sensitive little beasts. You should be able to go into design mode and select the check-box without selecting its label (or vice versa), then drag it around a bit to where you want it. However, you should also look at the properties of the checkboxes to assure they all have the same .HEIGHT and .WIDTH and that their .LEFT is also aligned correctly. I'm not sure why you have that reversal of box vs. label, but it should be easy to correct manually.

The question is, from where did you create that misbehaving checkbox? Did you use the same design-mode tools as used by the other three boxes, or was this a box that you copied from another source via cut/paste techniques?

All 4 checkboxes where drag & drop from the available list of field names from the table that their definitions are in.
Box 1 - Drag & Drop - Left text - right checkbox...... Same result for 2 & 3
Box 4 - Drag & Drop - Checkbox 1st then the text/label

 

[MajP]

I never seen that, but maybe what Doc said is the cause. I have never figured out how to use the layout to my advantage and it can drive you crazy moving things where you do not want them. I select all controls and then turn it off the layout "Remove Layout".

This thread kind of supports the layout grid being the issue where the label flips.

A2007 Check Box switching the Label Position Left/Right

I have forgotten where in Access 2007 the setting is which determines which side of a Check Box control the Label should be placed on. I know I have found it as I have Check Box controls with the Label not on the default side of the control. Suggestions? TIA!

www.access-programmers.co.uk

Try removing all layout.

 

[June7]

field that displays backwards

This sounds odd.

 

[Alan K]

One more possibility. If you simply want to move the checkbox to the other side of the label I find it much easier to move it this way.
Click on the box and not the label
Ensure you get the cross symbol and hold down
You should now be able to move the checkbox without moving the label.
Position the checkbox on the other side of the label

I went that avenue and in the result is when I got an error along the lines of Undefined label "xxxxxxxxx xxxx". Kind of gave me the feeling that I altered the structure doing that ... in the process Access didn't like it

 

[MajP]

I am putting my money on having to do with the grid layout. But hard to see without an image or uploading the DB. This form has a grid which often comes from using the Wizard to create form. If you click or select do you get yellow lines like this. If you drop a check box in one of those yellow areas it will but the label in one cell and the checkbox in another. Need to select everything and turn it off "no layout".

Like I said, I almost always turn it off. It gives me more frustration than benefit. I should spend some time and figure it out. Probably could save some time in the long run. But if you do not know how to use it, it can drive you nuts.