Posted on behalf of Richardall by firefytr.
I would like to make a form field that holds a date. I would like the format to be mm/dd/yyyy.
When you tab into the field, I would like a response box to ask "today" yes or no. If the answer is yes, I would like the field to be filled with today?s date. If no, I would like a drop down calendar to appear and the date can be chosen from that calendar. The chosen date will go in the field.
Once filed in, the macro will set the date to the mentioned format, will tab to the next field and exit.
Any help or suggested code would be greatly appreciated.
Richard