Use of Input Masks

  • Thread starter Thread starter boomrz2
  • Start date Start date
B

boomrz2

I am creating a database of college sports teams and want Access to help me
as I enter team names. When I type the first letter, say an 'I,' it will
suggest only teams beginning with an 'I' like Illinois, Illinois State, Iowa,
Indiana, etc. and as I type the second letter, third letter it will reduce
the options remaining. I thought I could do that w/ an input mask.
 
I am creating a database of college sports teams and want Access to help me
as I enter team names. When I type the first letter, say an 'I,' it will
suggest only teams beginning with an 'I' like Illinois, Illinois State, Iowa,
Indiana, etc. and as I type the second letter, third letter it will reduce
the options remaining. I thought I could do that w/ an input mask.
Click to expand...

An Input Mask basically dictates the format in which a user can enter data (for examples, a Date format that forces the
user to enter in mm/dd/yyyy format).

You can do what you're after using the AutoComplete feature of a Combo. Add a combo to your form and base that combo on
the table storing your TeamNames ... as the user types Access will attempt to match their entry with data already stored
in the table.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
yes, and this combo box is technically more powerful than the combobox
in VIsual Studio-- in other words, this autocomplete is probably half
of the reason that I use MS Access (data projects)
 
a a r o n . k e m p f @ g m a i l . c o said:
yes, and this idiot brain box of mine is technically more powerful than an egg
so I can count to at least 5; sometimes 6.
Click to expand...
 
Back
Top