User form with Input mask and default value

[ggodwin]

1.) I have a date form that I would like to maintain the format of mm/dd/yyyy and I would like the default date to be 01/01/2009.

2.) Along this line of questions. I also would like a different date field to also have the format of mm/dd/yyyy and have the default of "Today".

Any ideas for either one?

 

[missinglinq]

In Design View, select the first textbox (for the 1/1/2009 date.) Set it's Format Property to Short Date. Set its Default Value to #1/1/2009#.

Select the second textbox (for today's date.) Set it's Format Property to Short Date. Set its Default Value to Date().

 

[ggodwin]

Instead of short date can I give it mm/dd/yyyy.
I actually need to force this format.

I assume I can use this instead of the short date and also use Date()

 

[missinglinq]

If you're running an OS that's post-Windows98 and the regional settings are for the US, the Short Date is mm/dd/yyyy.