Default Date

[BurtonBach]

This question is in regards to a text box on a form in Access. Is there a way to make the default value setting default to the first day of the current month?

[nico5038]

Try, e.g. in the OnOpen event of the form:

me.txtDatefield = dateserial(year(date),month(date),1)

Nic;o)

[FishVal]

Something like
=DateSerial(Yea r(Date()),Month (Date()),1)

Kind regards,
Fish

[BurtonBach]

That worked. Thank you!