autocompletion of field

[kelly]

Hello! The database i'm working with requires that i type
in the exact same data in one field, for example, today's
date, for every new record (several hundred!). Is it
possible to have some type of autocompletion so that
Access automatically fills in each field with the last
info used in that field? Does anyone know if it's
possible to change the field properties to do this?

Thanks!
kelly

 

[Jon Frost]

look at the table in design view.
select the field you're talking about
look at the field properties (lower right of screen)
select "default values"

You can configure this property to automatically populate
the field with todays date.

hope this helps

-JF

 

[Aldo]

Hi Kelly,
It is possible to have a default value for the new
records you enter. But there is a limitation to this.
The default value will be added to every new record that
is inserted in the table. Changing the default value has
to be done manually.

How to set the default value:
-----------------------------
1> Open the table in design view
2> Select the field for which the default value has to be
set
3> Go to the general tab in the field properties
4> Put the default value in the column named "Default
value". for example if you want the default value to be
100 put 100 in the default value column.
If you want todays date put Date() in the
column "Default value"

You can email me if you need more clarification on how to
do this.

Have a good day,

Regards,
Aldo

 

[Tatenn Ra]

What if you are using an input form to input values into
a table. How would you use autocomplete to fill in
titles? Some of these titles are long and if the
information would just autocomplete it would mean less
typing.

Tatenn Ra
Oklahoma Department of Libraries