<div>
Sorry... &nbsp;correction in code:<br />
<br />

<pre><code id="code-20-41863035-1">    If Me.txtType2 = &quot;COMPLETE&quot; Then
        Me.chkbxConformed.Visible = True
        Me.txtRetDate.Visible = False
    End If

    If Me.txtType2 = &quot;PLATING&quot; Or Me.txtType2 = &quot;CALIBRATION&quot; Or Me.txtType2 = &quot;CHECK FIT&quot; Then
        Me.chkbxConformed.Visible = False
        Me.txtRetDate.Visible = True
    End If</code></pre>
</div>


Sorry...  correction in code:



    If Me.txtType2 = "COMPLETE" Then
        Me.chkbxConformed.Visible = True
        Me.txtRetDate.Visible = False
    End If

    If Me.txtType2 = "PLATING" Or Me.txtType2 = "CALIBRATION" Or Me.txtType2 = "CHECK FIT" Then
        Me.chkbxConformed.Visible = False
        Me.txtRetDate.Visible = True
    End If

<div>
<div class="content wysiwyg-content">
I have this code in the onprint event of the detail section of a report which works fine if there is data:<br />
<br />

<pre><code id="code-10-28979429-1">    If Me.txtType2 = &quot;COMPLETE&quot; Then
        Me.chkbxConformed.Visible = True
        Me.txtRetDate.Visible = False
    End If

    If Not IsNull(Me.txtRetDate) Then
        If Me.txtType2 = &quot;PLATING&quot; Or Me.txtType2 = &quot;CALIBRATION&quot; Or Me.txtType2 = &quot;CHECK FIT&quot; Then
            Me.chkbxConformed.Visible = False
            Me.txtRetDate.Visible = True
        End If
    End If</code></pre>
<br />
But if the report has no data I get an error that reads, &quot;You entered an expression that has no value. &nbsp;The debug highlights the first line of the code. &nbsp;How do I avoid this?
</div>
</div>


I have this code in the onprint event of the detail section of a report which works fine if there is data:

(CODE)

But if the report has no data I get an error that reads, "You entered an expression that has no value.  The debug highlights the first line of the code.  How do I avoid this?

Displaying on a 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.