Input Mask

[warmanlord]

Hello all,



It seems very simple what I am doing, but I am seeming to not come up with the correct answer yet. I am trying to add an input mask to my video Field, so that it is always enter correctly. V-1-2015, what I have so >"V-"099\-0000, but it is showing spaces if nothing is inputted for the 99 fields, if I add in !>"V-"099\-0000 it then removes those spaces since those are optional characters, but then the V is no longer capitalized. How can I correctly have an input mask that keeps the V always capitalized and have mandatory fields and optional fields without spaces. I want it to come out as V-1-2015, or V-11-2015 or V-111-2015. Thanks again for help.

[LaughingBull]

Mask Character Meaning.zip check this out hope it helps

[warmanlord]

Yeah i been using this site https://support.office.com/en-us/art...2-4a47832de8da

as it has provided most of the information, i just dont know what the formatting isnt excluding the spaces or when I am able to with the ! sign, it is no longer capitalized.

[LaughingBull]

when you input the data with the 3 optional space enter space space then the I and see it that works

[LaughingBull]

or use the &&& you must enter a space or a character

[warmanlord]

I guess there is two ways to go about this, do an input mask and then do a format on the input mask.

[warmanlord]

Ok, so after playing with it I got this >"V-"0&&\-0000!

that seems to work, even though I don't really get the \, since I had initially put it in "-"0000 but it was converted to \-0000

Is this a Valid input mask >"V-"0&&\-0000!, it seems to do what i want it to do, so far.

[warmanlord]

Never mind that seem to work but didnt as it requires you to enter a space or a digit in that area before the user can move on.

[warmanlord]

!>"V-"099\-0000;0

This seems to work and formats it correctly, the only other question i have is this, when typing you have to move the cursor to the last field after you input the first number how could I allow some who hit the - key to automatically move to the next field in the input mask, instead of using the cursor.

[LaughingBull]

in the table under is required select yes for that field so if they do not put all three in they will get a notice to enter before they can continue

[warmanlord]

in the table under is required select yes for that field so if they do not put all three in they will get a notice to enter before they can continue

Not entirely sure what you mean by this

[LaughingBull]

open your table in design mode where this data is stored ad select that field and the properties at the bottom one of the selections is is required and select yes. if a person does not enter 3 charters or spaces it will not let them continue