CSG-Analysis
asked on
how do I break the label/text box connection in MS Access 2007 report?
For layout purposes I need to break this connection. When I resize my date text box, it forces a change on the Name box that is superior in the grouping structure.
I do not remember this being an issue in 2003 and earlier.
I used to have a corner handle that I could grab to move and resize labels and text boxes separately.
Thanks
I do not remember this being an issue in 2003 and earlier.
I used to have a corner handle that I could grab to move and resize labels and text boxes separately.
Thanks
ASKER
I am trying to make it so that I can put the date information under the name information. When I resize one the other is affected. I cannot layer things. I cannot figure oiut how to ungroup the date controls.
The link was showing me 2000 or 2003 steps and it did not address what I am experinceing in the video (yeah video!). How do I break waht you see there? CSG-Analysis-420659.flv
The link was showing me 2000 or 2003 steps and it did not address what I am experinceing in the video (yeah video!). How do I break waht you see there? CSG-Analysis-420659.flv
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you verty much. Your solution worked and I now have the vocabulary to reserch it further on my own.
..OK
The odd thing is that if you select a single control and it's associated label, then remove them from the layout, Access will then move the remaining controls in the layout, to cover up this control.
This is very confusing as it "looks" like the control has been deleted, when in fact the remaining controls have "Covered" it.
I like the layout feature because it allows you to easily move/resize controls that may not have been the way you have liked them from the wizard.
But I will remove the Layout when it is time for me to do anything "Custom" (Like what you were trying)
;-)
Jeff
The odd thing is that if you select a single control and it's associated label, then remove them from the layout, Access will then move the remaining controls in the layout, to cover up this control.
This is very confusing as it "looks" like the control has been deleted, when in fact the remaining controls have "Covered" it.
I like the layout feature because it allows you to easily move/resize controls that may not have been the way you have liked them from the wizard.
But I will remove the Layout when it is time for me to do anything "Custom" (Like what you were trying)
;-)
Jeff
You may also be dealing with "grouped" controls. If so, you'll have to ungroup them in order to work with them individually:
http://office.microsoft.com/en-us/access-help/organize-controls-into-a-group-in-an-access-form-or-report-HA001044853.aspx
If you need to actually break the relationship between label and textbox:
You'll have to "delete" the label from the textbox, then just paste it back:
1) Highlight the LABEL portion of the textbox
2) Press Ctrl + C
3) Render focus to the appropriate section of your report (Detail, PageHeader, etc) - anywhere OTHER than the Textbox
4) Press Ctrl + V
This will remove your label and paste it to the selected area.