If statement case sensitive 1

[ajs1952]

I have a piece of code in my Access app that looks something like this:
if me.client = "PEV001" then ......

The client is actually "pev001".
On my computer it works fine and does the compare in a case insensitive way, however when copied to one user's PC the compare fails as it acts in a case sensitive way. Is it a setting maybe in Access or Windows?

thanks

 

[Crookshanks]

Did you check the Option Compare statement?

 

[mikej336]

if ucsase(me.client) = "PEV001" then

Uncle Mike

 

[missinglinq]

As Crookshanks hinted at, an Option Compare Binary statement is the only thing that will do this. If a module doesn't include an Option Compare statement, the default text comparison method is Binary! Perhaps the Compare statement was accidentally seleted on the offending machine?

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[missinglinq]

Seleted in the previous post should be Deleted! Only thing I dislike about this site; you can't edit your own posts for correction!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[ajs1952]

Yes I'd deleted the option compare statement. It is so familiar that it easy to forget how important it is! Thanks everyone.