Form field defaults to first day of month 1

[krets]

I haven't been able to find much about how to do this but I'm sure it can be done. I'd like to set the default date of a text box to the first day of the current month.

 

[PHV]

Set the DefaultValue property to:
=DateSerial(Year(Date()), Month(Date()), 1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[krets]

Man, that's so simple. My Google mojo has failed me.