Input Mask

Apa itu Input Mask

Input mask (topeng masukkan) adalah format kawalan masukkan data sebagai panduan kepada pengisi data. Ini sangat penting demi menjamin keseragaman data di dalam pangkalan data.

Contoh karekter Input Mask

Character	Explanation
0	User must enter a digit (0 to 9).
9	User can enter a digit (0 to 9).
#	User can enter a digit, space, plus or minus sign. If skipped, Access enters a blank space.
L	User must enter a letter.
?	User can enter a letter.
A	User must enter a letter or a digit.
a	User can enter a letter or a digit.
&	User must enter either a character or a space.
C	User can enter characters or spaces.
. , : ; - /	Decimal and thousands placeholders, date and time separators. The character you select depends on your Microsoft Windows regional settings.
>	Coverts all characters that follow to uppercase.
<	Converts all characters that follow to lowercase.
!	Causes the input mask to fill from left to right instead of from right to left.
\	Characters immediately following will be displayed literally.
""	Characters enclosed in double quotation marks will be displayed literally.

Cara membuat Input Mask

1)      Jadual adalah pada Design View.

2)      Klik pada nama medan. (contoh medan saiz kepala  jadual pelajar seperti di bawah.).

3)      Input mask berada di field properties.  

4)      Klik pada input mask dan setkan format 99::_  pada ‘Input Mask Wizard’ dialog box.

5)      Pilih ‘Social Security Number’ dan klik next. Tukar input mask kepada 99::_.

*Paparan akan menjadi seperti yang di bawah