Reply to thread

Message: [QUOTE="StargateFan, post: 7419361"] Oh, I should have waited. I had 2 tabs left to look at in my FF and found what seems to be the answer (I never knew this, but it does seem to work!!): ----------------------------- 2013-06-16 15:42:00 ([URL]http://www.pcreview.co.uk/forums/input-mask-date-t1678393.html[/URL]) 6th Aug 2003 What you really want is a format, not an input mask. I never put an input mask on a date/time field as it gets in the way more than it helps. Savvy users know that they can enter today's date with 8/6 or 6/8 (depending on their Regional Settings) - or even using Ctrl-; An input mask would require more keystrokes. You are not restricted to the formats presented in the pick list; you can set a custom format such as mmmm d, yyyy -- Joan Wild Microsoft Access MVP ----------------------------- Sure enough! Instead of choosing a format in the first box in the table's design view (i.e., "General Date", "Long Date", etc.) we just need to type in the format we want. In this case, mine is this: ddd.mmm.dd.yyyy (just like I use in Excel half the time!) Then I saved the table and sure, enough, all the entries now show in this format: Sun.Jun.16.2013. And when you exit the field format, the date format is displayed as this: ddd\.mmm\.dd\.yyyy Neat. Now I have a way to get what I need each and every time, I think with regards to date format. Cheers. [/QUOTE]