MS Access - Tables Part 3: Input Masks

This video covers how to ensure a user enters values into a field that is in the correct format based on Input Masks and the codes they use to represent the different options.
Microsoft Access Tables Video Series
Part 0 What is a database - • MS Access - What is a ...
Part 1 Creating a database and tables - • MS Access - Tables Par...
Part 2 Validation Rules - • MS Access - Tables Par...
Part 3 Input Masks - • MS Access - Tables Par...
Part 4 Lookup Wizard - • MS Access - Tables Par...
#MrLongEducation #Access #InputMask

[@anelemsibi3249]

Remember, Don’t do it the Long way, Do it the MrLong way 😌

[@cherithlucas5062]

Mr.Long is a legend for this

[@hassansarbazhassan6286]

such a great explanation, thanks a lot

[@indigo-nk2iu]

Thank you very much, this is very useful.

[@AsadShaheenAkram]

Thank you Mr. Long

[@stripes6149]

dankie👍🏻👍🏻

[@Cya_De_Saint]

Thank you sir for doing this for free

[@tinaiv2959]

this literally saved me for wednesday😭😭🙏🏾🙏🏾

[@MrLongITandCAT]

Good luck for tomorrow!

[@lizziemutangirwa4832]

I'm writing tomorrow and this helped so much

[@MrLongITandCAT]

@@lizziemutangirwa4832 I hope it went well today!

[@zainabrazeen7554]

thank you so much

[@teachkhmerbinary]

I like this video it help for exam.

[@juanjosecalomardodiaz906]

Wat about if I want to type 1 and I want to show 001 ? and if I type 2 002 ans so on?

[@KesleyNgonyamo-ey8zl]

Was helpful

[@londianaplays1713]

🎉

[@KesleyNgonyamo-ey8zl]

U of are good

[@Sunil_13797]

Ho did you type "Date_of_Trip" in field heading..
I mean how did you put underscore symbol (_)..
Please help

[@MrLongITandCAT]

It's always best to have field names without spaces so either use DateOfTrip or use underscores for Date_of_trip

[@Sunil_13797]

@@MrLongITandCAT But sir when I try to put underscores or fullstop symbol between two words, it shows that "you can't put this type of characters"..
I couldn't use this symbol. please sir tell me how to type thi

[@Sunil_13797]

@@MrLongITandCAT for example sir if I try to write Sr.No in field, then because of that full stop (between Sr and No), access show a dialogue box says that - "the field name you entered does not follow Microsoft access object naming rules."
So my question is that how to put fullstop in access field ?

[@MrLongITandCAT]

@@Sunil_13797 Try put the field name in square brackets [Sr.No]. Not sure if it will work but give it a try

[@MrLongITandCAT]

@@Sunil_13797 Where are you typing this or changing the name. Can you take a screen shot of it?

[@ozzyplayz7082]