For Full versions of my videos or to join my mailing list go to : http://www.pcwebinars.com Access input mask and input mask wizard - Access 2007 2010 2013 2016 tutorial for beginners
this video I want to go back and cover
that input MK that we started on a
different video so I'm going to right
click on this table and pick on design
view this of course is where we can uh
change fields or add fields or delete
Fields uh that are already in the table
so we have this phone
number and let's say you want the
parentheses and the dash for the phone
number to come up automatically what you
do is you come down here and you pick on
input mask now there's some input masks
that are built right in uh and I'm going
to show you that in a second but let me
show you how you can get help on these
fields or you know a lot of help in in
Access if we hit F1 the F1 function
key it's going to give you what we call
context sensitive help so there's how
it's talking about the input Mass
property so I want to pick here where it
says input Mass
property and then you're going to see
the help screen now the help screen a
lot of times has a complicated language
like here it says variable and combo box
and different terms that you may not be
used
to but the help screen usually is pretty
good at showing you examples uh so like
here it's telling you what to use for
your input Mass that's pretty useful
information and then down here it's
going to give you some examples so
really you can just cut and paste these
and then this would be the the results
that you would get so the help screens
and access are not bad sometimes they're
they have really technical language but
many times they we'll have uh at least
one or two useful examples down there
the way I got to that help was F1 uh you
know and that's going to give you
context sensitive help of course the
other way to get help is over here using
the um using the question mark So if I
go back into the help
screen you can build your input mask
using any combination of these
characters or you can use these examples
and just copy and paste those right in
and that's
fine uh but there's some input masks
that are built right in that's called
the input mask wizard to get to the
input mask wizard we're going to pick on
the three dots over
here now uh notice how there's some that
you use all the time phone number Social
Security number zip code extension and
you have different ones like that the
things for dates so um let's say we're
going to pick the phone number and then
I'm going to hit the tab key so I'm in
the Triad field over here here you can
try before you buy a type of thing right
so I'm going to type in
215
5551 1212 notice how the parentheses
came up automatically and the Dash came
up automatically that's what the input
mask does for you when um so we're going
to pick on finish and now the input mask
wizard fill in the input mask property
for you and that's the whole per purpose
of the wizard now if you go back into
that help screen you can see what these
characters mean and then you can start
to make your own input Mass but I really
like that input Mass wizard I'm also
going to apply the input mask for the
fax number obviously that's going to be
a phone number type of format as well so
once again we're going to pick on that
field we're going to pick on input mask
we're going to pick on the three dots
over
here and then it says I have to save my
table so I will do that and then we're
right back to the input mask wizard of
course I want to pick the phone number
this time again again now this time I
don't have to try it because we already
tried that we know it's going to work so
I could just pick on phone number and
pick on finish and it fills in the input
Mass property okay so that way when we
start to enter data the phone number
will will come up with the parentheses
and the dashes and that's the whole
purpose of the input Mass property is to
be able to help you preformat those
fields for data entry