Format Date Field

gschimek

Registered User.
Local time
Today, 12:01
Joined
Oct 2, 2006
Messages
102
I saw a thread once that explained how to format a date or phone number field after you've entered the data, but I can't find it again.

You do it so that you don't have the __/__/__ or the ___-___-____ pop up in the field and don't have to worry about inadvertently starting typing the data in the middle of the field instead of the beginning.

Anybody know where that thread is at, or know how to do that?
 
Have you looked up the Format() function in VBA help?
 
in the Input Mask of the text box type in 99/99/99;;_ or 99-99-99;;_
 

Users who are viewing this thread

Back
Top Bottom