By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,688 Members | 1,738 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,688 IT Pros & Developers. It's quick & easy.

Display Message if No Data Exist in a report

P: 2
I need to display a message on a report if there is no data to report
Jul 30 '10 #1

✓ answered by Steven Kogan

Place this code in the report's NoData event:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Report_NoData(Cancel As Integer)
    MsgBox "There is no data"
    Cancel = True
    End Sub

Share this Question
Share on Google+
2 Replies


Expert 100+
P: 107
Place this code in the report's NoData event:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Report_NoData(Cancel As Integer)
    MsgBox "There is no data"
    Cancel = True
    End Sub
Jul 30 '10 #2

P: 2
Thanks for your help Steven!
Jul 30 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.