Only adding default date when actually entering a new record.

[evaraine]

Hi,

I am relatively new to building access databases. I am able to add today's date as a default but the problem is that it is always visible in what would be the next record even if I am not adding one. I only want this default date to appear if I am actually adding a new record. I have been searching for an answer for this in forums and tutorials all morning but can't seem to find a solution.

Does anyone know if this is possible and could point me in the right direction?



Many thanks.

[aytee111]

If you remove it from the table then it won't show up as you see it. But then you will have to put it there manually in the BeforeInsert event (if you are using a form) or somehow run a query when a new record is added.

[CJ_London]

assuming the default value in the field is set to date(), in your form, change the default value for the date control to Null.

It will not be populated until you start to add a new record - so the new record line will be blank