How do I compare a bit value in VBA to use in an IF statement for an Access Report?

I have an Access 2003 frontend connecting to an SQL database backend on our network. My employer needed a check box added to mark customers that are to receive only exact counts on their shipments (no overage). I successfully added the bit field (ExactCount) to the Customer table (dbo_Cust). I was also able to successfully display the bit field in the query attached to the final report.

Within the report is an unbound value (txtShipQty1). I checked the VBA module for the report and modified the code to match my alterations. I've tried using several variations to compare the string (= 0, <> -1, <> 1, = False, <> True, etc.) but it doesn't seem to be recognizing the value and making the comparison the way I intended.

I've spent about 4 hours on this and I'm fresh out of ideas (willpower).

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
  Rem Exact Count Modifier Check
  If ExactCount <> -1 Then
    If Qty < 500 Then
      txtShipQty1 = Qty + 25
    ElseIf Qty < 2500 Then
      txtShipQty1 = Qty + 50
    Else
      txtShipQty1 = Qty * 1.02
    End If
  Else
    txtShipQty1 = Qty
  End If
End Sub

Select allOpen in new window