hi i have a text box for entering password. i have to compare the entered text with a hard coded text. the password should come in *******. how can i achieve this?
Go to the properties of the textbox in your form and click on input mask and select Password from the available options. Then when the user types into the textbox the results will appear as asterisks.
Have set the input mask on the table as well? if so remove it. By setting it on your form and in your table you won't be able to evaluate it. If you want to hide it in your table as well you may need to encrypt the password before passing it to your table. Then decrypting it when you want to compare it.
The actual text is stored in the table even if you have the Password input mask set for both fields as you should. You can remove the input mask from the table field to check the results but don't forget to put it back.