Use of Input Masks

[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.

 

[Scott McDaniel]

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.

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

 

[a a r o n . k e m p f]

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)

 

[Aaron Kempf knows nothing]

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.