Blank page in Report after Conversion from Access 97 to XP

[JohnHarkins]

OK, I keep thinking I know something about Access and then whammo, I get a slap on the face. Today it's a case of having made a nearly successful conversion from Access 97 to 2000 for a client's application. Lo and behold, I get a blank page after the first sub-report.

I've tried removing stuff from the report (which consists of umpteen sub-reports in various places including the header) to see what's causing the problem, but I can't seem to make the thing fail in a way that lets me know what to fix. Let me explain. The blank page is truly blank; whereas all the other pages are numbered. The only thing that I can think of (and I haven't checked it out yet) is that the margins are different by default from A97 to XP and somehow I'm getting the old overflow of a wide page onto a second sheet of paper.

What I'd like help with, if you don't mind, is a strategy for figuring out what's wrong. One idea I had was to start building the report from scratch and putting in the controls and such in order to check what's going on. Almost any idea I come up with seems cumbersome and I keep thinking that there's a way to diagnose the problem intelligently. Guess I'm lacking "intelligent" today.

Thanks for listening!

Regards,


John Harkins

 

[KenReay]

Hi

If it was the margins problem, every other page would be blank, or it is a single page report ?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[JohnHarkins]

Thanks for your prompt response.

You're right; it's just a single page. Now, it appears, the behavior has changed (most likely due to something I tried) and only when I omit the "cover page" will the blank page appear. The code I used to omit the cover page follows:

If Forms![frmSelectReports]![cbxShowCoverPage] = True Then
Section(1).Visible = True
Else
Section(1).Visible = False
End If

This worked in Access 97, but I think this may be a difference between the two versions of Access. What do you think?


John Harkins

 

[KenReay]

Hi

Does this not point to the fact that it is the cover page which is casing the problem ?

Have you examined it to ensure that it is not exceeding margins

Do you have any means of printing the cover page only, does that produce a sprrious blank page?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[KenReay]

Hi

Does this not point to the fact that it is the cover page which is casing the problem ?

Have you examined it to ensure that it is not exceeding margins

Do you have any means of printing the cover page only, does that produce a spurious blank page?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[JohnHarkins]

If I print the cover page, then the blank page does not appear. In other words, it would seem that the code I used to suppress the printing of the page merely suppresses printing data on a page. Ugh!

John Harkins