input mask (1 Viewer)

[rainbows]

hi ,

i use this for the input mask on some of my fields >"PCO"00000;0;? this is for the "works order number" but i have just been asked if it could be modified so i could also put the word "stock" into that field sometimes as we need to purchase stock ie maybe cleaning material etc

can it be modified to use letters as well as numbers

thanks steve

 

[June7]

Input must follow the input mask structure. If you want to allow user to type "stock" instead of 5 digits then have to change the mask to allow any alpha-numeric input. Use "A" or "a" in place of each of the 5 "0". https://support.microsoft.com/en-us/office/control-data-entry-formats-with-input-masks-e125997a-7791-49e5-8672-4a47832de8da#:~:text=Customize Input Masks from the Input Mask Wizard,arrow and select a suitable mask... See More.

 

[Cotswold]

FORMAT - INPUT MASK PROPERTY - PICTURE
0 := 0 to 9 entry required
9 := number or space entry not reqd
# := number or space entry not reqd + and - allowed
L := Letter A to Z entry reqd
? := Letter A to Z entry optional
A := Letter or number entry reqd
a := Letter or number optional
& := Any character or space entry reqd
C := Any character optional
.,:;-/ depends on settings in International section of control panel
< := All to lower case
> := All to upper case
! : = Causes input mask to fill from right to left
\ := causes the following character to be literal )\A shows A
@ := Text character or space required

 

[Pat Hartman]

I would suggest doing what you should have been doing all along. Store the prefix separately. Now you have two options. You can still default to PCO but use a combo so the user can pick Stock. Do NOT use a mask unless you want the field to appear to be zero filled.