date value

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

I have a macro that first sends and email with data from a form.
Then I have in the macro to setvalue of a text box to the current date which
the value is set to =date().

the value that appears in the form is 12/30/1899.
 
The current date is supposed to be filled in the text box when the macro runs.
How do I check for a zero value when I am trying to pull the current date?
 
Maybe the textbox has default set and the macro is not working. Check the
field that the textbox is bound to also.
 
Back
Top