Report design view. Layout / Move up a section

[Frances]

If I put a text box and its associated label in the detail section of a
report, I often want to put the label in the header section above. If I right
click on the label I get a menu with Layout / Move up a section (greyed out).
This is just what I want if it werent greyed out.

When I create a grouping in design view the label and textbox go into the
detail section. But I can right-click and choose Layout / Move up a Section
to move the label although I cant drag and drop it.

I dont understand why Move up a section is sometimes greyed out. What is
going on? Any help would be appreciated.

 

[Duane Hookom]

The label control is probably the "child" of the text box. If this is the
case, you can't separate them into different sections. You could select the
label, press Ctrl+X to cut it to the clipboard, click in the group header
section, and press Ctrl+V to paste.

I expect you can move a text box with its label up a section.

I wasn't aware of this feature. Must be 2007 or something I don't have
turned on.

 

[Frances]

Yes, I am sorry I omitted to mention that I am using Access 2007. This 'Move
up a Section' and 'Move down a Section' must be referred to somewhere in the
help I guess if only I knew how to find it. I have used the cut and paste
but the Move up a section is great when it works but I am not sure why it is
sometimes greyed out.

 

[Duane Hookom]

I'm not sure why this would be disabled. However, it might not make sense to
move a control up a level if it isn't linked uniquely to the higher level
record.

 

[Frances]

I am doing the ECDL advanced databases course and one of the questions we
have is to replace, in a report, the fields First Name and Last Name by a
single concatenated field called Full Name.

The labels are in the Page Header section and the textboxes in the Detail
section. I have just tried putting a new text box in the Detail section for
the new concatenated field and have discovered that if on the Arrange tab I
choose Tabular Layout then the label goes up into the Page Header section
while the textbox remains in the Detail section. There is a dashed line
showing that they are paired. This is just the result I wanted.

Duane thanks for your help, just chewing it over with someone is a great
help. Perhaps you could help me with my other post on how to remove a custom
page margin setting in Access 2007. someone has put one on my computer at
college. It comes up with a yellow star so I think it has been made some kind
of favourite and is at the top of the list of normal, wide and narrow
margins. It mucks up my reports by imposing custom margins and causing blank
pages to display in print preview. I know its easy to sort out when you know
the cause but it took someone else to alert me to what was going on. I would
like to know how to remove this setting.

Many thanks

Thank

 

[Duane Hookom]

Please start a new thread with your new question.

 

[Frances]

I already have but no-one has replied. Its called Custom margins in Page
Layout in Access 2007, posted 7 April in this forum.

 

[Guest]

osoft.com...