Can anyone tell me why this does not work? When I step through it, it skips the intIDLen = 7 and goes to the intIDLen = 9 no matter what.
Thanks, Pat

If Left(cmbSite.Text, 7) < 8 Then
intIDLen = 7
ElseIf Left(cmbSite.Text, 9) > 8 Then
intIDLen = 9
End If