EllenG Posted December 30, 2004 Posted December 30, 2004 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.
transpower Posted December 30, 2004 Posted December 30, 2004 Exact(field1,field2), returns a Boolean result (1 or 0).
Recommended Posts
This topic is 7336 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now