To obtain the date format described in your question, use the Format
function with the following arguments:
Format(Date(), "ddmmyyyy")
e.g.:
?Format(Date(), "ddmmyyyy")
08062019
Whilst you can change the display format of an AutoNumber to display static content surrounding the incrementing section of the field, by changing the Format
property to something like:
"ID"000
This does not change the actual data held by the field, but only the way that such data is displayed by the field (the field will still contain an incrementing Long Integer).
You also cannot use expressions within this Format
property, and so you would not be able to insert the current date as a prefix.