There's a setting that you can use that makes text comparisons case insensitive.

Add
Option Compare Text
Right at the top of the module--outside any procedure.

Then you can just compa

if current = temp then

If case never matters for any procedure in that module, it's an easy fix.


"Sabo, Eric" wrote:

I have the following:

If current = temp then

End if

My problem is the following:

Current = Apple
temp = APPLE

How can I compare these two strings without the case involved. I want the
if statement to treat them as equal.

Thank,
Eric Sabo

--

Dave Peterson