In a report, how do I unlink a data field with its label?

[COTC]

I am trying to separately adjust the width of a data field and its associated
label. I could do this in Access 2003 by clicking a number of times on the
data field and it would allow me to widen the data field without changing the
width of its label. How can I do this in Access 2007?

 

[Jeff Boyce]

When I open a form in design view, click on a textbox (with an attached
label), then drag the handle in the middle of the box, the textbox control
changes size, while the label control remains the same.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Al Campagna]

COTC,
Should be the same as other versions of Access
Select the label only.
Use Ctrl - Insert to Copy the label.
Hit the Delete key to delete the label.
Select the form, and hit Shift-Insert to Paste your label
back on the form.
The label and the text control are now individual.

But... it sounds like you may have "Grouped" the two objects. In
that case, select both objects and select UnGroup in the
Arrange/ControlLayout ribbon. Now, the label and the text control be
"associated", but will size/move/etc.. like your 2003 version.

--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."