• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

Missing lines when previewing/printing anything other than entire report - ACC2K

Hi,

I"m using Access 2000 on Windows XP SP2.  The problem I'm having is a report dropping the last line of text in a text box control.  The report is multi-page report with two sub-reports.  The first sub-report control will never run past the first page of the parent report.  The second sub-report (sub1) control always runs across multiple pages.  What I've found is that the first instance of sub1 on any page but the first page drops the last line of text in the control when the navigation controls are used to skip pages.  For example, on an 8-page report, if I jump to page 8, pages 2-7 will be missing the line of text.  However, if I page to page 8 one page at a time, none of the text is lost.  For examples assuming the text in sub1 is always the same, please see below:

TEXT ON FIRST INSTANCE OF SUB1 WHEN SKIPPING FROM PAGE 1 TO PAGE 8

PAGE 1
The quick
brown fox jumped
over the lazy dog

The quick
brown fox jumped
over the lazy dog

PAGES 2-7
The quick
brown fox jumped

The quick
brown fox jumped
over the lazy dog

PAGE 8
The quick
brown fox jumped
over the lazy dog

The quick
brown fox jumped
over the lazy dog

TEXT ON FIRST INSTANCE OF SUB1 WHEN PAGING FROM PAGE 1 TO PAGE 3, THEN SKIPPING TO PAGE 8

PAGES 1-3
The quick
brown fox jumped
over the lazy dog

The quick
brown fox jumped
over the lazy dog

PAGES 4-7
The quick
brown fox jumped

The quick
brown fox jumped
over the lazy dog

PAGE 8
The quick
brown fox jumped
over the lazy dog

The quick
brown fox jumped
over the lazy dog

This problem also arises when I print a single page of the report as opposed to printing the entire report.

The sub-report controls are set to shrink/grow, as are the controls on the sub-reports.  At this point I'm at a loss.  Anyone have any ideas?  In addition, please let me know if I've not explained this clearly enough.

Thanks,

Tony
0
2030penn
Asked:
2030penn
  • 6
  • 3
1 Solution
 
tbsgadiCommented:
Hi 2030penn,

Have you tried using a different printer driver?

Gary
0
 
2030pennAuthor Commented:
Gary,

Thanks for the response.  Yes, have tried three different drivers, all with the same result.

Tony
0
 
Jeffrey CoachmanCommented:
2030penn,

It is difficult to visualize what you have and what you need.
    "A picture is worth a thousand words"
It would be easier if you just downloaded a sample of your Database/Report/Form/Code& ect, and removed any sensitive data.
But leave enough data to so we can see the issue.
Along with the post, please explain, in detail, what you are trying to achieve.
Post to:
http://www.ee-stuff.com
&and post the link to that file here

Jeff Coachman

0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
2030pennAuthor Commented:
mbizup,

I didn't receive notification of boag2000's post, and never thought to post a copy of the db.  Please leave this question open and I will upload copy of db later today or sometime tomorrow.

Thanks
0
 
2030pennAuthor Commented:
I have uploaded the file as requested (and rephrased the question).  It can be found here:

https://filedb.experts-exchange.com/incoming/ee-stuff/7065-db1.zip

Thanks
0
 
Jeffrey CoachmanCommented:
2030penn,

Interesting issue!
:-O

I cannot pin-point the exact cause, but I believe it stems from the fact that at about 3000 characters, the subreport must move to a new page.

I also believe that when you jump to the last page, then to the previous page, ...Access "retreats" back to the previous page.
Hence the report page cannot be generated in the correct sequence (First page-->NextPage, ...ect) So Access cannot properly display it.

In any event, this does not occur in Access 2003.

The only way I was able to get the report to display properly was to open the report by a menu.
The report would open hidden.
It would use a hidden textbox to get the number of pages.
Then it would Page Down to the last page, then page back up to the first Page, then un-hide the report.
This would force the report to properly generate the pages behind the scenes.
(A public variable was also used to determine if the report wan opened from the menu or not.)

Here is a sample to demonstrate this technique.

JeffCoachman

Access--EEQ22890016-TruncatedNot.doc
0
 
2030pennAuthor Commented:
Hey Jeff,

Thanks for taking a look at this.  I'll take a look at your attachment and let you know how things turn out.  I appreciate the help.
0
 
2030pennAuthor Commented:
mbizup,

Thanks for the heads up on how to request deletion.  I'm still learning the ins & outs of this forum and appreciate the tip.
0
 
2030pennAuthor Commented:
Jeff,
Thanks again for the help.  The solution works well with smaller sets of records, but appears to blow up a bit with larger sets.  I tried varying the # of page ups/downs, hard coding to specific values, and other things.  What worked best was leaving out the page up but it was still inconsistent.  I think, in addition to the paging issues you pointed out, there may be contributing factors such as # of pages, length of data in the control, etc.  In any event, I've reached the point of diminishing returns and will accept things as they are.

Thanks again for the assistance.

Tony
0
 
Jeffrey CoachmanCommented:
2030penn,

<there may be contributing factors such as # of pages, length of data in the control, etc. In any event, I've reached the point of diminishing returns >
Yeah, that's what I figured as well.

You are probably not sorting or filtering on this field, so at 3000+ characters, perhaps it would be better to just insert the data into a NotePad, WordPad, or Word Document, ... then link to it as an OLE field.

As a last resort, you can also try splitting the memo field data into separate text fields of 255 characters each, then concatenate them back together
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_23020454.html?sfQueryTermInfo=1+concaten+jeffcoachman+memo

JeffCoachman
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now