Auto fill text?

B

Bob Quintal

=?Utf-8?B?SlJTTkhFQ0k=?= <[email protected]>
wrote in
Thanks for the response.....no I am not using the relational
aspect although that would be a solution. I was hoping there
was just a qucik autofill feature available but it sounds like
there is not from your response
If you are not using the relational Aspect, you are better off
going back to Excel.

Q
 
J

JRSNHECI

Hi! Does Access have a feature you can turn on so that once you start typing
a database text entry it will attempt to match a previous entry in the
database and fill in the rest of the text for you (similar to Excel)? For
example, I have a project database where all my jobs are listed. When i
enter a new job and go to input the Customer Name (i.e. Microsoft) I would
like Access to fill in the rest of the workd Microsoft once it recognizes the
first couple of characters. Any help would be appreciated
 
F

Falty

Judging by the sounds of your question you are not using the relationional
aspect of access database. To do this you would have a table which contains a
list of customers names as well as other customer information. The table
would have a primary key which identifys each record (customer), and on the
table where you are entering the details such as e.g. 'customer name' you
would have a customerID field as well, these would be linked by a
relationship . You would then use a combo box to do what you originally asked.
 
J

JRSNHECI

Thanks for the response.....no I am not using the relational aspect although
that would be a solution. I was hoping there was just a qucik autofill
feature available but it sounds like there is not from your response
 
T

Tom Ventouris

Chage thje customer name field on your form to a combo box and set its row
source to the same as the control source. You will be able to type in new
customers and it will predict while you are typing.
 
C

clarson

You also have to have the AUTOEXPAND set to YES in the properties of the
combo box. If it is set to know it will not predict.
 
Top