They are if used alone - which is what I meant?Unfortunately, Date() and Now() are not available for Calculated Fields, but DateSerial() is.
Hi Micron. I just tried it, and I got an error.They sre if used alone - which is what I meant?
That's a very good point!bk1010,
One other aspect others have not touched on regarding calculated fields; they are calculated when the record is added/updated. They don't "Magically" change if the record is not touched.
For your calculation it would ONLY be valid for the date it is added/updated. The next day, it wouldn't show "Out of Date" unless you forced the record to be changed.
Thanks. I must have been thinkng about Default Value property. Put it down to me being bored while waiting (still) and not being able to test something I don't use.Hi Micron. I just tried it, and I got an error
Hi. No worries. Good luck with the repair(?).Thanks. I must have been thinkng about Default Value property. Put it down to me being bored while waiting (still) and not being able to test something I don't use.
Did you tryI tried now() as default value in the field
=Now()
as the default value for the field?Access creates the new record automatically, with the default values in it.
Access creates the new record automatically, with the default values in it.I would question why you are creating an "empty" record as soon as the previous one is completed.
Why not wait until you need the new record?