Now()

[SantaUK]

Is there a way that I can get Access to default a field to yesterdays date?

 

[Van T. Dinh]

Set the DefaultValue to:

Date() - 1

HTH
Van T. Dinh
MVP (Access)