Examples of default values in fields (MDB)
From Microsoft Office Access 2003
Examples of default values in fields (MDB)
Note The information in this topic applies only to a Microsoft Access database (.mdb).
| Expression | Default field value |
|---|---|
| 1 | 1 |
| "MT" | MT |
| "New York, N.Y." | New York, N.Y. (note that you must enclose the value in quotes if it includes punctuation) |
| " " | Zero-length string |
| Date( ) | Today's date |
| =Yes | Yes displayed in the local language of the computer. |