Lines on a report

[Microsoft]

Access 2007

I have a report that has 2 section headers.
Area Header
Item Heaer
Detail Section
Item Footer

I have a line in the Item Footer and also a line between records in the
detail section for easy viewing of records.

Is there a way of NOT printing the line in the detail section when it is the
last record.

At the moment when I print the report I get two lines when it is the last
record - 1 from the detail section and 1 from the Item Footer section.

When the Item Footer line prints I don't want the last line in the detail
section to print.
Hope I've explained this

Thanks
Al

 

[Marshall Barton]

Access 2007

I have a report that has 2 section headers.
Area Header
Item Heaer
Detail Section
Item Footer

I have a line in the Item Footer and also a line between records in the
detail section for easy viewing of records.

Is there a way of NOT printing the line in the detail section when it is the
last record.

At the moment when I print the report I get two lines when it is the last
record - 1 from the detail section and 1 from the Item Footer section.

When the Item Footer line prints I don't want the last line in the detail
section to print.

Why not just get rid of the line in the group footer?

 

[Duane Hookom]

I expected this reply from you Marsh. I can picture the expression on your
face as you typed.

You have brought some form of predictability to my afternoon. THANKS, I
needed that ;-)

 

[Marshall Barton]

I expected this reply from you Marsh. I can picture the expression on your
face as you typed.

You have brought some form of predictability to my afternoon. THANKS, I
needed that ;-)

Gee, Duane, it's not often that I am thanked for being a
stress reliever, but I am glad to help in any way I can ;-)

Is the new job is getting to you or is it just a case of
cascading crisis? ;-))

 

[Duane Hookom]

It's mostly the new job compounded with sitting at my old desk and old
co-workers stopping by with new projects :-( My new boss has new projects.

A few breaks (no lunch today) just to check the news groups and get some
relief.

 

[Marshall Barton]

It's mostly the new job compounded with sitting at my old desk and old
co-workers stopping by with new projects :-( My new boss has new projects.

I'm sure you'll work it out, somehow ;-)
But what does an old retired guy like me know ;-))

A few breaks (no lunch today) just to check the news groups and get some
relief.

Hey, I thought you alreay knew how to post one handed while
eating with the other hand. But it's good to hear that you
still have your priorities properly sorted ;-))

 

[Microsoft]

because that wouldn't give me what I want.

the line in the detail section does NOT go all the way across the report and
is only a thin line.
the line in the footer section goes ALL the way across the report and is a
much thicker line.

I suppose i could get rid of the line in the footer if there is a way to
code a change to the length, position and thickness of the LAST line in the
detail section........

 

[Marshall Barton]

You can tell when the last detail is being processed with
this kind of arrangement.

Add a text box (named txtDtlCnt) to the Item group header
section. Set its control source to =Count(*)

Add a text box (named txrLine) to the detail section. Set
its control source to =1 and RunningSum property to Over
Group.

Then you can use code in the detail section's Format event
procedure to hide the line in the last detail:

Me.linDetail.Visible = (txrLine = txtDtlCnt)

 

[Duane Hookom]

If the OP wants to hide the last instance of the line, I think the code
should be:
Me.linDetail.Visible = (Me.txrLine <> Me.txtDtlCnt)

I prefer to add the "Me." since it is a little less confusing for us more
mature guys.

--
Duane Hookom
Microsoft Access MVP

You can tell when the last detail is being processed with
this kind of arrangement.

Add a text box (named txtDtlCnt) to the Item group header
section. Set its control source to =Count(*)

Add a text box (named txrLine) to the detail section. Set
its control source to =1 and RunningSum property to Over
Group.

Then you can use code in the detail section's Format event
procedure to hide the line in the last detail:

Me.linDetail.Visible = (txrLine = txtDtlCnt)
--
Marsh
MVP [MS Access]

because that wouldn't give me what I want.

the line in the detail section does NOT go all the way across the report and
is only a thin line.
the line in the footer section goes ALL the way across the report and is a
much thicker line.

I suppose i could get rid of the line in the footer if there is a way to
code a change to the length, position and thickness of the LAST line in the
detail section........


"Marshall Barton" wrote