Lines on a report

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

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
 
Microsoft said:
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.
Click to expand...


Why not just get rid of the line in the group footer?
 
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 ;-)
 
Duane said:
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 ;-)
Click to expand...


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? ;-))
 
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.
 
Duane said:
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.
Click to expand...

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.
Click to expand...

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 ;-))
 
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........
 
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)
 
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


Marshall Barton said:
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
Click to expand...
Click to expand...
 
Back
Top