Do the input strings have the same capitalization?
Yup
...might have gotten declared as a variant instead of a string type
Doesn't seem to be what's at fault - checking using VarType() spits '8' back out, which means it's a string. And I don't think there's anything about the length one way or the other in it - it's just declared as "Dim strEventType"
If that doesn't help, I'd probably put "strEventType = "Absence" " before the IF and see what happens.
No change in behavior, no matter what's in strEventType. Sigh.
Ah well, I shall slap the ID numbers of the event types in it to see if *that* changes anything.
no subject
Yup
...might have gotten declared as a variant instead of a string type
Doesn't seem to be what's at fault - checking using VarType() spits '8' back out, which means it's a string. And I don't think there's anything about the length one way or the other in it - it's just declared as "Dim strEventType"
If that doesn't help, I'd probably put "strEventType = "Absence" " before the IF and see what happens.
No change in behavior, no matter what's in strEventType. Sigh.
Ah well, I shall slap the ID numbers of the event types in it to see if *that* changes anything.