Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 919
  • Last Modified:

How to separate the label control from the textbox control in a report.

In Access 2003, I could delete the link between a label and it's associated textbox. Then I could move each in report design view.

How can I do this in Access 2007?
SeperateControls.jpg
0
Dovberman
Asked:
Dovberman
  • 3
1 Solution
 
rockiroadsCommented:
you could try ctrl-x (cut) the label, then to use it elsewhere, paste it (ctrl-v)
0
 
rockiroadsCommented:
sorry, I forgot to add, thats how you can do it in A2003, did you try that same way in A2007?
0
 
TextReportCommented:
In Access 2007 you will need to change the Remove the Control Layout in the Arrange Ribbon, Control Layout, Remove option then you can treat the label control as separate from the textbox.
Cheers, Andrew
0
 
rockiroadsCommented:
when u cut/paste it comes up with a dropdown with a exclamation mark. Click that and hit ignore error will remove that.
there is settings somewhere I think. In A2003, you can disassociate a label then click on menu option format/set control defaults, that then doesnt create a label when u create a textbox. Same in reports as well I think.
Not sure where that is in A2007
0
 
DovbermanAuthor Commented:
Thanks,

I never would have figured that out in less than one thousand menu combination tries.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now