Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

how do I break the label/text box connection in MS Access 2007 report?

Posted on 2011-03-10
5
Medium Priority
?
1,171 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:CSG-Analysis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 85
ID: 35095449
Are you viewing the Report in Design view, or in Layout view? Layout view is much different.

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.
0
 

Author Comment

by:CSG-Analysis
ID: 35095603
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
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 200 total points
ID: 35096826
If I am reading your post correctly, you need to "Remove" the layout.
The layout feature is new in Access 2007

To do this, for all the controls:
Open the Report in design view
Select All the controls (Press Ctrl-A)
Then navigate:
Arrange-->Control Layout-->Remove
0
 

Author Closing Comment

by:CSG-Analysis
ID: 35097663
Thank you verty much. Your solution worked and I now have the vocabulary to reserch it further on my own.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35098077
..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
0

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question