automatic

[John W. Vinson]

Hi all,

In excel if i start typing in a column it would provide a automatic
choice based on the previous data in the column. For example if a column
has three cell containing cotton, yarn and chem, in the 4th cell when i
type c it will let me put cotton by pressing enter. Is that possible in
access table or in form?

Mosaddeq

A Combo Box control has an "autocomplete" feature that resembles this. You can
use a combo in a form or a table. If you're tempted to use it in a table read
http://www.mvps.org/access/lookupfields.htm first: most of us dislike using
table datasheets for data interaction, they're not designed for it.

Be sure you're fully aware that though a table Looks like a spreadsheet it
really ISN'T. Databases are emphatically *not* "spreadsheets on steroids";
they require different logic. See

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[Mosaddeq Aziz]

Hi all,

In excel if i start typing in a column it would provide a automatic
choice based on the previous data in the column. For example if a column
has three cell containing cotton, yarn and chem, in the 4th cell when i
type c it will let me put cotton by pressing enter. Is that possible in
access table or in form?

Mosaddeq

 

[pb110005-2351]

Hi all,

In excel if i start typing in a column it would provide a automatic choice
based on the previous data in the column. For example if a column has
three cell containing cotton, yarn and chem, in the 4th cell when i type c
it will let me put cotton by pressing enter. Is that possible in access
table or in form?

Mosaddeq

 

[pb110005-2351]

Hi all,

In excel if i start typing in a column it would provide a automatic choice
based on the previous data in the column. For example if a column has
three cell containing cotton, yarn and chem, in the 4th cell when i type c
it will let me put cotton by pressing enter. Is that possible in access
table or in form?

Mosaddeq

 

[TedMi]

A combobox control has similar functionality. The row source of the combo
should be query that selects from the field containing cotton, etc.,
preferably sorted ascending. Then typing in the input section will take you
to the first entry beginning with that letter. You could then move the
selected entry to the proper input field in the AfterUpdate event of the
combo.
-TedMi