If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lines on a report
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 |
#2
|
|||
|
|||
Lines on a report
Microsoft wrote:
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? -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Lines on a report
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 Hookom Microsoft Access MVP "Marshall Barton" wrote: Microsoft wrote: 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? -- Marsh MVP [MS Access] |
#4
|
|||
|
|||
Lines on a report
Duane Hookom wrote:
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? ;-)) -- Marsh MVP [MS Access] |
#5
|
|||
|
|||
Lines on a report
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 Hookom Microsoft Access MVP "Marshall Barton" wrote: Duane Hookom wrote: 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? ;-)) -- Marsh MVP [MS Access] |
#6
|
|||
|
|||
Lines on a report
Duane Hookom wrote:
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 ;-)) -- Marsh MVP [MS Access] |
#7
|
|||
|
|||
Lines on a report
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 in message ... Microsoft wrote: 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? -- Marsh MVP [MS Access] |
#8
|
|||
|
|||
Lines on a report
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] Microsoft wrote: 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 Microsoft wrote: 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? |
#9
|
|||
|
|||
Lines on a report
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" wrote: 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] Microsoft wrote: 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 Microsoft wrote: 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? |
#10
|
|||
|
|||
Lines on a report
Duane Hookom wrote:
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. Thanks for catching that, Duane. -- Marsh MVP [MS Access] |
|
Thread Tools | |
Display Modes | |
|
|