You'd want to check if RoadName is NULL at that point, or better yet, check to see if the ID for that record is null.

If IsNull(CustomerID) then...

Thanks for responding so quickly. Unfortunately I've tried every iteration of the code that I  can think of...
If IsNull(TblID) Then ... BEFORE the Me.Filter = True   statement and after,  and I tried If IsNull(Roadname) Then ...
in different places within the FindRoadBtn subroutine but the result is always the same if the entered Filter value or character string is NOT in my database, and my form completely goes blank but is set to a "Filtered" state, and I have to click on the 'Toggle Filter' button to "reset" my Form. I would like to be able to tell the user that they searched on a value that is NOT in the database

and AUTOMATICALLY RESET the Form Filter (Me.Filter = False).

DLookup

Yeah, that's the best bet. Like Kevin said, perform a DLookup to check if that value is in there.

Gentlemen, once again, THANK YOU. However I found a much simpler solution to my problem (in my opinion since I am a novice at this) which did not involve the use of either the NZ nor the DLookup...  (See my code below...)
Private Sub FindRoadBtn_Click()

    Dim RdNam As String
    
    RdNam = InputBox("Please Enter All or Part of the Road Name:", "Search For Road Name", RoadName)
    
    If RdNam = "" Then
        MsgBox "The Road name you entered was NOT FOUND !", vbInformation, "Record Not Found"
        Exit Sub
    End If
        
    Me.Filter = "RoadName LIKE """ & RdNam & "*"""
    Me.FilterOn = True
    
    If Me.Recordset.RecordCount = 0 Then
        MsgBox "The Road name you entered was NOT FOUND !", vbInformation, "Record Not Found"
        Me.FilterOn = False
        Exit Sub
    End If
          
End Sub