Dont print 2nd page of report if field is Null VBA

[dtaylor89]

I have a report that is two pages, the second page only has an picture embedded. This is not a required field, so If the field is null only print page 1 else print both pages.

Any suggestions?

 

[mdlueck]

I have on some reports used the following to prevent displaying an error message:

=IIf([Report].[HasData],[statuscode],"N/A")

Perhaps you could do something similar to detect if there is a graphic or not.

Not sure how you would tell Access to skip the page in the not case.

 

[dtaylor89]

Can you do something like if field is null only print page 1?
Can you do a open report and only reference a page number?

 

[mdlueck]

Perhaps skin the cat in the direction of making a "report and report lite" and have some logic pre-detect that the graphic is missing and thus pull up the "report lite" which is the report minus the second page.