I have a TextBox with the ControlSource pointing to a date field of a table. The date format is set to "R" and the InputMask is set to "99/99/9999 99:99:00 AA". The first entry into this TextBox works as expected. The first keystroke clears the previous entry if one exist and displays the mask skipping over the format characters as you enter data. The next entry displays as the first but now characters are pushed to the right as keystrokes are entered and the mask is ignored.
How can this be avoided?
Also, I noticed in the builder there is a prompt for “Data type”. It is Currently set for “Character”. I tried setting it to “Date” but it didn’t make any difference.
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108