December 30, 200421 yr How can I compare 2 fields that are the same, except for case, and have them come up as not equal? Example: Field-1="ABC", Field-2="abc". When comparing in an If statement (If field-1 <> field-2), it fails the test and identifies the fields as equal. I tried using Proper(Text) but it still doesn't work. Thanks.
Create an account or sign in to comment