In my application, a text box control resides in a form. The text box
control is unbound, but--assuming all edits are passed when the user
click a command button on the form--the contents of the text box
control end up in a field in a table with a data type of Date/Time.
Is it possible to set up a mask on this text box control such that if
one types any any of the following sequence of characters into the
text box
06/25/04
6/25/04
062504
the result is that:
a) the date 06/25/04 is displayed in the text box
b) the date 06/25/2004 gets written to the field in the table
(assuming all edits are passed after the user clicks the command
button)
If it is not possible to accomplish this using only a mask, is it
possible to accomplish it through some combination of mask and VBA
code?