Report Filter Statement

[hascons]

Hello Everyone,

I'm having a problem building out a filter statement when the it needs to determine if a Boolean was Passed



I've attached a photo showing the code in breakmode and stepping through the code. For some reason the code will not pick up when I've entered a "Yes" or "NO".

I've tried using the standard "<>" at first to determine if the value of the textbox = "Yes" or "No" but neither of these options work.

This Textbox is part of an Unbound Access Form that acts as a report Builder to filter reports so there is no recordset attached to any of the texboxes. I need to remove the Single quotes around the Words "Yes" or "No" when the filter is expecting a Boolean type variable. I can do this manually but would rather be able to Identify the text as Boolean with a simple "Yes" or "No" and build string accordingly.

[hascons]

I did find the solution to this problem

I Used The Following Code

If Len(Trim(Me.f2_FilterField) & vbNullString) > 0 And Len(Trim(Me.f2_Value) & vbNullString) > 0 Then
    
        If Me.f2_Value <> True Then
      
            If Len(sSql) > 6 Then
                sSql = sSql & " AND " & Me.f2_FilterField & "= '" & Me.f2_Value & "'"
            Else
                sSql = sSql & Me.f2_FilterField & "= '" & Me.f2_Value & "'"
            End If
            
        ElseIf Me.f2_Value = True Then
    
            If Len(sSql) > 6 Then
                sSql = sSql & " AND " & Me.f2_FilterField & "= " & Me.f2_Value
            Else
                sSql = sSql & Me.f2_FilterField & "= " & Me.f2_Value
            End If
        
        End If
    
    End If

[davegri]

Try

If Not me.f2_value = "Yes" AND Not me.f2_Value = "No" Then