Masking table field

When we make a table for our database. Then sometimes we need to mask field for input our data into table. It’ll be needed for input password, telephone number, currency etc.
For masking a field you have to set mask rule at input mask option.

MS-Access mask field

set at input mask Use for
password use this field for invisible password input
“tk”# Use it get tk string after your amount. You can use here any thing like dollar ,dinar, Euro, etc.
00000-0000 0000 like as mobile number 01813-677 141

Example : I have included an example for field masking. It used for input mobile number and invisible password.

Look at the image. After masking i have get out put to input my data as my wish. You can mask field for your database in different purpose.

mask field

Share on :

Leave a Reply

8 + three =