>But when I log in with my password it gives me password invalid. Here is my code for the onclick event for logging in:
>
>

>LOCATE FOR UPPER(login.userid) = UPPER(ALLTRIM(THISFORM.UserName.DisplayValue))
>
>IF .NOT. ENCRYPT(thisform.Password.Value, "aqwsrweq") == Login.password
>		WAIT WINDOW "The user name or password is incorrect. Please try again." TIMEOUT 1.5
>		THISFORM.Password.Value = ""
>		THISFORM.Password.SetFocus	
>	ELSE
>		thisform.release
>ENDIF
>

>
>Similarly, here is my code for the onclick event when creating a user:
>
>

>INSERT INTO 'login' ( userid, password) ;
>VALUES  (thisform.username.value, thisform.password.value)
>
>REPLACE password WITH ENCRYPT(thisform.password.Value, "aqwsrweq")
>		
>thisform.username.value=""
>thisform.password.Value=""
>

As Borislav said, make sure lengths of comparison are igual. Either PADx() or as he also suggested use ALLTRIM() in both sides of the equation.

Note: In your example I see you read the entered value directly from the screen (ThisForm.Password.Value). That opens a security hole as you seemingly don't validate what they are allowed to enter before using it (opening yourself to SQL injection and other malicious types of code). It is best to save it to a variable or property then validate it to be within accepted parameters (min and max sizes, accepted characters only, password complexity requirements, etc.) before actually using it for the query.

HTH