Solved

Access 2003:  Report - Group Totals - separator line in the group footer is not always printing

Posted on 2011-03-24
2
432 Views
Last Modified: 2012-05-11
Hi EE,

Below is an uploaded mdb of 3 report.
 parent report - fixed fields
 subrep1 - course information for fall semester
 subrep2 - course information for sprint semester

Am using subReports as pseudo columns

Grouping the subReport by Semester.
In the Group footer, i drew a horizontal separator line, that i realize is not always showing.

if you run the subreport2 by itself, you will the last separator line printing
if you run the parent report that includes 2 subreports, the last separator does not show on the printed page


tx in advance for your ideas, sandra
0
Comment
Question by:mytfein
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 14

Accepted Solution

by:
pteranodon72 earned 500 total points
ID: 35209340
There is no attachment to view, but my experience with intermitant lines always seems to happen with lines set to Border Style=HairLine. Try changing to Border Style = 1pt and see that is dependable.
Hope this helps,
pT72
0
 

Author Comment

by:mytfein
ID: 35209375
Hi PT72,

tx sooo much,

followed your suggestion.... beautiful....  sorry forgot to upload file....

you solved it... tx, s
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question