ACCESS FEED: RE: [MS_AccessPros] Login Form

Minggu, 05 Juni 2011

RE: [MS_AccessPros] Login Form

Kumar-

I'm not sure if KeyPress or KeyDown will give you that info. You could check
the entered data in the password control's BeforeUpdate event to see if they
entered all caps and warn them then.

Use the StrComp function to do a case-sensitive compare:

If StrComp(Me.Pswd, UCase(Me.Pswd), vbBinaryCompare) = 0 Then
MsgBox "You might have Caps Lock turned on."
End If

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of access_kri
Sent: Sunday, June 05, 2011 6:00 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Login Form

Dear all,
I have a log-in form, which has case-sensitive password field. I want a
warning to be displayed in a label when the CAPS Lock is on similar to when it
is displayed when we log-on to windows. Can you suggest how I can accomplish
this.

Thanks and regards,
Kumar

------------------------------------

Yahoo! Groups Links