Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 DISCONNECT CONTROLS

Author  Topic 

doco
Yak Posting Veteran

77 Posts

Posted - 2010-05-03 : 16:23:35
For some demented reason MS believes the default behavior of controls on a form should be that they are all connected somehow. In other words after using the form wizard to create a form, all labels and text boxes are connected in a way that does not allow movement/sizing of one or the other without moving/sizing all - really frustrating and ridiculous concept. Surely there is a way to turn this bug feature off?

Using Access 2007

TIA

Education is what you have after you've forgotten everything you learned in school

SMerrill
Posting Yak Master

206 Posts

Posted - 2011-04-29 : 23:17:14
I'm using Access 2010.

You need to look at the Form design Tools > Arrange toolbar, which has a "Remove Layout" tool. This will decouple a textbox from it's corresponding label, and allow them to move independently.

1. Go to form Design view.
2. Find the Arrange toolbar (Alt-JA helps).
3. Click on a textbox. It will highlight orange. If a label also highlights with it, click the Remove Layout tool (4th from the left.)

NOTE: The label and the control get a dark-blue handle in the upper-left. Click on it, and you get a North-south-east-west cursor to scoot the things around.

This should do it for you.


~ Shaun Merrill
Seattle area
Go to Top of Page
   

- Advertisement -