How do I set up an Auto text in Access?

S

Sim

I want to know how do I have the Auto complete function in Access. As in when
I have a word which is used repetedly in the databse how can I get Acess to
complete it automatically for me.
For example: If I have a movie database and I have Kevin Costner as its main
lead how do I go about not typing his name again and again and let Access do
it.Can I have Access complete the name for me automatically ?
 
S

Sprinks

Hi, Sim.

If you have a table of Actors, such as:

ActorID AutoNumber (Primary Key)
ActorFName Text
ActorLName Text
BirthDate Date
....etc.

then you can use a combo box, with its AutoExpand property set to Yes. To
display the first and last names on your form, yet store the ActorID into a
numeric field in your table, set the following combo box properties:

RowSource SELECT Actors.ActorID, [ActorFName] & " " & [ActorLName] AS
ActorName FROM Actors;
BoundColumn 1
ColumnWidths 0";2" (or whatever width displays the longest name)
ControlSource The name of the numeric field in which to store the ActorID
AutoExpand Yes

Beyond combo boxes, I no of no other Access feature that fills in text based
on an "oft-used" paradigm.

Hope that helps.
 
Top