1021
Using Queries to Extract Data from a Database
Setting a Default Value
The Default Value property supplies the starting value for any field. Whenever a field has a
typical or common value, you can use this property to supply that value; the user can over-
ride it with a different entry, if necessary. The default value can be a constant, such as
0 or
California or #12/31/2003#, or an expression from the Expression Builder. If you want a
field to default to a value of today’s date, for example, use
Date() as the Default Value prop-
erty. In an invoice table, you might set the PaymentDue field to a default value of
[InvoiceDate]+30; to specify a different ...