Calendar control default value

  • Thread starter Thread starter Lee Hunter
  • Start date Start date
L

Lee Hunter

What is the correct method or syntax to accomplish:

Cal.Value = IIf(IsNull(Date_In), =NOW(),_ Date_In.Value)

Where Cal is tha ActiveX calendar control and Date_in is
a text box bound to a date field in the DB.

That is to say, if the current record has no date, start
the calendar with today's date.

Thanks for your assistance.
 
I don't do that because the form is used to both update
and add records. For new records I need the user to pick
the date from the calendar. For update the date remains
the same.

Thanks for the reply.
 
Back
Top