In this Access forms tutorial you will learn how to make Access forms more usable with controls while increasing the integrity of your Access database.
Sometimes it may be necessary to set field properties from the form itself. For example, on the New Orders form for our bookstore shown below, we want to set up the Order Date field to auto-fill with the current date each time an order is entered. This way, our employees will not have to worry about entering a date on the form because the form will do it for them.
In our example, we want to set the Order Date field to auto-fill with the current date. Refer to the picture below. Notice that we have the Order Date field highlighted on the form itself. On the Property Sheet, we have Order Date showing in the Selection type drop-down list.
Because we want the Order Date to auto-fill, we must set the default value to always enter the current date.
The Expression Builder contains many commonly used expressions for database functions. Explore them by clicking the various files in the lefthand column.