How do I autofill Fields on Access 2013?

Answer 1

There are 3 different ways to autofill fields in Access: (1) Setting a default entry at the table design level will result in that field being filled whenever a new record is added to the table. This works well when you always want the same default entry for every record - for example, defaulting a number field to a 0. (2) The default entry can be set at the field property level on a form instead of at the table level. This allows more flexibility because form A might have a different default than form B (for example). (3) Macros and/or VBA can also be used before or after updates of data that can fill defaults. This method allows calculations and/or logic statement to be take into consideration in determining what the default needs to be!

Answer 2

In the design view of the table, there is an entry named default. In that field you would enter what you would want the default value to be. Then when you open the table the value you put in that line, will show automatically on the line.