About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
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.
