Discussion Locked

Inconsitent Report

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I am using VB6, Access97 as the database the DataEnvironment and the Data Report designer that commes with VB6.

I have designed a query in the dataenvironment. I pass a parameter to the query and then produce a report which is bound to this query.

the sequence is this, I add information to the table, then I try to print the same information by getting the information from the table using a parameter (identifier) query. then I show a report bound to the query.

The result I get is that the first time I get a printed page, i capture the second record and print then I get a blank report, I capture a third record then I get a printed report, the forth will be blank and so on.

Thanxs

3 replies

by john_wills

Look at your report design. It is probable that your page is too wide for the paper you are using. If you are using American Quarto(8.5"x11"), your form should be no more than 6.5" wide. In Design View you can tell how wide your form is by comparingthe width of the colored background with the scale above. What is happening is that your even-numbered pages are showing the excess width of your report.

This discussion is closed to new replies.