Null in field, return a word in report

[MicMic]

I have a field VendID and if there is not a vendor entered in that field I want it to say NO Vendor instead of it being blank

[ADezii]

I have a field VendID and if there is not a vendor entered in that field I want it to say NO Vendor instead of it being blank

You cannot modify the Report Field directly since it is Bound and a Report is static. What you can do however, is the following:

1. Make the [Designation] Field invisible.
2. Create an Unbound Text Field on the Report and name it txtDesignation.
3. Place the following code in the Format() Event of the Detail Section:
   

   Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
     If IsNull(Me![Designation]) Then
       Me![txtDesignation] = "NO Vendor"
     Else
       Me![txtDesignation] = Me![Designation]
     End If
   End Sub

[MicMic]

Thanks for getting back to me, I will try it out and see if I have any other issues.