How to exclude a report from printing if it has no information in it ?


Question

This is probably a pretty newbie question, but what I'm looking to do is this. I have a print macro that allows me to print all my daily forms with one buttom push. However, one of my reports can sometimes have no info in it and I'd like to exlude it from printing... How?

Answer

Hank,

Check Online help - HasData property and NoData event.

This function is one of the possible answers to your question:

Private Sub Report_NoData(Cancel As Integer)
   MsgBox "No Data !"
   Cancel = True
End Sub

HTH,
Shamil


Copyright 1999-2008 by Shamil Salakhetdinov.  All rights reserved.