Expert: Rob Henderson - 2/8/2005

Question
Hi Rob.
I am creating a database with my scientific articles.
In the field Author I am frequently using the same names so I have to retype the same name many times.

My question is:
Is there any sort of AutoComplete function (like in MS Excel) so if the first few characters that I type match an existing entry in the column, then Access fills in the remaining characters for me?

Thanks
Nick


Answer
Hi Nick

No there's not a such.

What I would normally do here is create a lookup table contianing the author information and then set a field in your main table that uses a combo to look up that information.

There is a wizard for creating this type of relationship in the field - select it from the boittom of the field type tab or look at the Lookup tba ppresent in text fields (but not used).

That way when completing a record you'll select from a drop down box for youre author data.

Give me a shout if you're having problems with this.

rob