<div>
Try using the Filter property on Report_Open<br />
<br />
Gary
</div>


Try using the Filter property on Report_Open

Gary

<div>
<a href="http://msdn.microsoft.com/en-us/library/aa195885(office.11).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/aa195885(office.11).aspx</a>
</div>


http://msdn.microsoft.com/en-us/library/aa195885(office.11).aspx [http://msdn.microsoft.com/en-us/library/aa195885(office.11).aspx]

<div>
<div class="content wysiwyg-content">
I need to skip a detail row in an Access report when one of the detail values is null. I can't change the query that feeds the report to eliminate the null rows for reasons I won't go into here. <br />
<br />
I saw this solution in another post:<br />
<br />
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)<br />
&nbsp; &nbsp; If Me.MyID = 1 Then Cancel = True<br />
End Sub<br />
<br />
I added this to the report code, but it does not seem to get called. I even changed to condition to if 1=1 then cancel = true, but it still did not work. 
</div>
</div>


I need to skip a detail row in an Access report when one of the detail values is null. I can't change the query that feeds the report to eliminate the null rows for reasons I won't go into here. 

I saw this solution in another post:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If Me.MyID = 1 Then Cancel = True
End Sub

I added this to the report code, but it does not seem to get called. I even changed to condition to if 1=1 then cancel = true, but it still did not work. 

Skip a detail row in an access 2007 report

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.