suppress group header

[brown234 via AccessMonster.com]

I have a report w/5 group headers. It's a budget worksheet that displays the
account (up to 5 levels) and expense and income. The problem is that it
displays the income or expense on the line below the account it refers to.

Administration
Office
Print Shop
$1,000

The $1,000 should be on the same line as Print Shop.

The expense and income fields are in the detail section of the report.

Thanks for any help.

Karla

 

[Marshall Barton]

I have a report w/5 group headers. It's a budget worksheet that displays the
account (up to 5 levels) and expense and income. The problem is that it
displays the income or expense on the line below the account it refers to.

Administration
Office
Print Shop
$1,000

The $1,000 should be on the same line as Print Shop.

The expense and income fields are in the detail section of the report.

If the heights of the two sections are set appropriately
(the same in this case?), then just add a line of code to
the account header section's Format event procedure:

Me. MoveLayout = False

 

[brown234 via AccessMonster.com]

The income/expense still shows up on the next line. I have the height set to
0 in all my sections. I put the format event procedure in the Detail section
where the income/expense fields are. If I put this procedure in the group
header sections then there's overlapping of the fields. It looks like this:

Administration
Office
Print Shop
Other $1,000
Equipment

The $1,000 is a Print Shop expense but shows up in the line below it.

Thanks for any further help.
Karla

I have a report w/5 group headers. It's a budget worksheet that displays the
account (up to 5 levels) and expense and income. The problem is that it

[quoted text clipped - 8 lines]

The expense and income fields are in the detail section of the report.

If the heights of the two sections are set appropriately
(the same in this case?), then just add a line of code to
the account header section's Format event procedure:

Me. MoveLayout = False

 

[Marshall Barton]

The code would have to go in the header with Print Shop.
And, yes, if the detail section has controls in the same
vertical "band" as the header above it, they will overlap.
You can not expect to put controls in the same vertical band
and have them on the same line without getting some overlap.
If That's the case, then just move the detail section's
controls to the right so there is no overlap.

Maybe you need to explain what the "Other" represents. Is
it a label in the detail section? Maybe the "Other" is
another group header and just appears there because you put
the code in the wrong (detail) section.
--
Marsh
MVP [MS Access]

The income/expense still shows up on the next line. I have the height set to
0 in all my sections. I put the format event procedure in the Detail section
where the income/expense fields are. If I put this procedure in the group
header sections then there's overlapping of the fields. It looks like this:

Administration
Office
Print Shop
Other $1,000
Equipment

The $1,000 is a Print Shop expense but shows up in the line below it.

I have a report w/5 group headers. It's a budget worksheet that displays the
account (up to 5 levels) and expense and income. The problem is that it

[quoted text clipped - 8 lines]

The expense and income fields are in the detail section of the report.

If the heights of the two sections are set appropriately
(the same in this case?), then just add a line of code to
the account header section's Format event procedure:

Me. MoveLayout = False

 

[brown234 via AccessMonster.com]

Thanks Marshall. The extra line is no longer an issue. The issue now is
that if there's an income/expense in a lower level account and is null in the
levels above it, then the income/expense duplicates/displays in the upper
levels also. The level names should appear but the income/expense should
display nothing. My report looks like this:

Level 1 Income
Expense
Level 2 Income
Expense
Level 3 Income
Expense
Level 4 Income
Expense
Level 5 Income
Expense

The levels are each a group header with the account name, income and expense
fields in it. Nothing in Detail Section.

Karla

The code would have to go in the header with Print Shop.
And, yes, if the detail section has controls in the same
vertical "band" as the header above it, they will overlap.
You can not expect to put controls in the same vertical band
and have them on the same line without getting some overlap.
If That's the case, then just move the detail section's
controls to the right so there is no overlap.

Maybe you need to explain what the "Other" represents. Is
it a label in the detail section? Maybe the "Other" is
another group header and just appears there because you put
the code in the wrong (detail) section.

The income/expense still shows up on the next line. I have the height set to
0 in all my sections. I put the format event procedure in the Detail section

[quoted text clipped - 20 lines]

 

[Marshall Barton]

There seems to be something strange going on here. How can
a group level exist if there are no details to go with it???

Normally, a group header/footer might display an aggregate
(Count, Sum, etc) of the levels below it. But you say it is
duplicating the data in the lower levels??? I think I am
completely lost on what you have for data records and the
controls in each header section. And where do these
income/expense values come from??

I would have expected details in each level 5 group and some
kind of total of those details in the level 1 through 5
group headers. Since I'm getting the impression that your
report is not the usual arrangement, I guess I need more
specific information about the report and its data records.
--
Marsh
MVP [MS Access]

Thanks Marshall. The extra line is no longer an issue. The issue now is
that if there's an income/expense in a lower level account and is null in the
levels above it, then the income/expense duplicates/displays in the upper
levels also. The level names should appear but the income/expense should
display nothing. My report looks like this:

Level 1 Income
Expense
Level 2 Income
Expense
Level 3 Income
Expense
Level 4 Income
Expense
Level 5 Income
Expense

The levels are each a group header with the account name, income and expense
fields in it. Nothing in Detail Section.

The code would have to go in the header with Print Shop.
And, yes, if the detail section has controls in the same
vertical "band" as the header above it, they will overlap.
You can not expect to put controls in the same vertical band
and have them on the same line without getting some overlap.
If That's the case, then just move the detail section's
controls to the right so there is no overlap.

Maybe you need to explain what the "Other" represents. Is
it a label in the detail section? Maybe the "Other" is
another group header and just appears there because you put
the code in the wrong (detail) section.

The income/expense still shows up on the next line. I have the height set to
0 in all my sections. I put the format event procedure in the Detail section

[quoted text clipped - 20 lines]

Me. MoveLayout = False