Text Box validation problem!!!!!

[joePC]

Hi,

Im trying to validate a txt box,

If txtoverdraft.Text = "No", I want it so that any instance of no e.g. No, nO, no, NO what would I use here?

If txtoverdraft.Text = "No" And txtbalance.Text < 0 Then
 
'if its not at the end of the file
If (Not datCities.Recordset.EOF) And (Not datCities.Recordset.EOF) Then
 
        'Message box
        MsgBox "Overdraft not available for this client, Please enter balance greater than 0"
        
        txtbalance.Text = ""
        
        'Doesn't save
        Action = 0
        
        txtbalance.SetFocus
 
End If
End If

Thanks joePC