date value

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.
 
R

Rpettis31

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?
 
K

KARL DEWEY

Maybe the textbox has default set and the macro is not working. Check the
field that the textbox is bound to also.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top