In Access 2002 (SP2) with WinXP, I have 2 strings that I
am comparing when a user enters their password into a
LogIn form. The variables and their values are below:

' This is the password stored in the User's table
sPassword = "robert"
' This is the password the entered in the password text
box on the LogIn Form
sPasswordEntered = "ROBert"

When the following code is executed, I get a True result,
when in fact I should get a FALSE result:

If sPassword = sPasswordEntered Then
bSuccess = TRUE
Else
bSuccess = FALSE
End If

What is the best method to ensure that the user has
entered the correct password (case sensitivity does matter
here)?

Try the ASC function:

If Asc(sPassword) = Asc(sPasswordEntered) Then ...

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org


"Tony_VBACoder" <(E-Mail Removed)> wrote in message
news:192e401c44ca3$2acdd810$(E-Mail Removed)...
> In Access 2002 (SP2) with WinXP, I have 2 strings that I
> am comparing when a user enters their password into a
> LogIn form. The variables and their values are below:
>
> ' This is the password stored in the User's table
> sPassword = "robert"
> ' This is the password the entered in the password text
> box on the LogIn Form
> sPasswordEntered = "ROBert"
>
> When the following code is executed, I get a True result,
> when in fact I should get a FALSE result:
>
> If sPassword = sPasswordEntered Then
> bSuccess = TRUE
> Else
> bSuccess = FALSE
> End If
>
> What is the best method to ensure that the user has
> entered the correct password (case sensitivity does matter
> here)?
>

Add Option Compare Text to your module


"Tony_VBACoder" <(E-Mail Removed)> wrote in message
news:192e401c44ca3$2acdd810$(E-Mail Removed)...
> In Access 2002 (SP2) with WinXP, I have 2 strings that I
> am comparing when a user enters their password into a
> LogIn form. The variables and their values are below:
>
> ' This is the password stored in the User's table
> sPassword = "robert"
> ' This is the password the entered in the password text
> box on the LogIn Form
> sPasswordEntered = "ROBert"
>
> When the following code is executed, I get a True result,
> when in fact I should get a FALSE result:
>
> If sPassword = sPasswordEntered Then
> bSuccess = TRUE
> Else
> bSuccess = FALSE
> End If
>
> What is the best method to ensure that the user has
> entered the correct password (case sensitivity does matter
> here)?
>

Sorry that should be Option Compare Binary, Option Compare Text will produce
the result you are current experiencing.


"solex" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Add Option Compare Text to your module
>
>
> "Tony_VBACoder" <(E-Mail Removed)> wrote in message
> news:192e401c44ca3$2acdd810$(E-Mail Removed)...
> > In Access 2002 (SP2) with WinXP, I have 2 strings that I
> > am comparing when a user enters their password into a
> > LogIn form. The variables and their values are below:
> >
> > ' This is the password stored in the User's table
> > sPassword = "robert"
> > ' This is the password the entered in the password text
> > box on the LogIn Form
> > sPasswordEntered = "ROBert"
> >
> > When the following code is executed, I get a True result,
> > when in fact I should get a FALSE result:
> >
> > If sPassword = sPasswordEntered Then
> > bSuccess = TRUE
> > Else
> > bSuccess = FALSE
> > End If
> >
> > What is the best method to ensure that the user has
> > entered the correct password (case sensitivity does matter
> > here)?
> >
>
>

"Roger Carlson" <NO-Rog3erc-(E-Mail Removed)> wrote in message
news:uKu$(E-Mail Removed)...
> Try the ASC function:
>
> If Asc(sPassword) = Asc(sPasswordEntered) Then ...

Asc() only evaluates the first character in a string though.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Tony_VBACoder wrote:

>In Access 2002 (SP2) with WinXP, I have 2 strings that I
>am comparing when a user enters their password into a
>LogIn form. The variables and their values are below:
>
>' This is the password stored in the User's table
>sPassword = "robert"
>' This is the password the entered in the password text
>box on the LogIn Form
>sPasswordEntered = "ROBert"
>
>When the following code is executed, I get a True result,
>when in fact I should get a FALSE result:
>
>If sPassword = sPasswordEntered Then
> bSuccess = TRUE
>Else
> bSuccess = FALSE
>End If
>
>What is the best method to ensure that the user has
>entered the correct password (case sensitivity does matter
>here)?


I like this way:

If StrComp(sPassword, sPasswordEntered, _
vbBinaryCompare) = 0 Then
bSuccess = TRUE
--
Marsh
MVP [MS Access]

Thanks.

StrComp worked the Best.


>-----Original Message-----
>Tony_VBACoder wrote:
>
>>In Access 2002 (SP2) with WinXP, I have 2 strings that I
>>am comparing when a user enters their password into a
>>LogIn form. The variables and their values are below:
>>
>>' This is the password stored in the User's table
>>sPassword = "robert"
>>' This is the password the entered in the password text
>>box on the LogIn Form
>>sPasswordEntered = "ROBert"
>>
>>When the following code is executed, I get a True
result,
>>when in fact I should get a FALSE result:
>>
>>If sPassword = sPasswordEntered Then
>> bSuccess = TRUE
>>Else
>> bSuccess = FALSE
>>End If
>>
>>What is the best method to ensure that the user has
>>entered the correct password (case sensitivity does
matter
>>here)?
>
>
>I like this way:
>
>If StrComp(sPassword, sPasswordEntered, _
>
vbBinaryCompare) = 0 Then
> bSuccess = TRUE
>--
>Marsh
>MVP [MS Access]
>.
>