User defined date format

G

Guest

Hello,

I need to allow the user to enter a new date in the format "mm/yyyy". I
have set the field up in the table as a date/time data type and have added a
new input mask using the Input Mask Wizard as "99/000;0;_", named "MthYr
Date". I leave the Format property field on the General tab blank. When I
close the table, the Format property reverts from being a blank to Short
Date, but the table retains the input mask. When the user enters a new date,
the input mask looks like it's supposed to (mm/yyyy), but once the user
clicks on to a new field, the date field looks like "mm/dd/yyyy" instead of
"mm/yyyy".

I need what the user sees to remain in the "mm/yyyy" format once they leave
the date field.

Any help would be appreciated. Any negative, non-constructive comments,
please keep to yourself.
 
J

J. Goddard

Set the format property to what you want as well. The mask property is
only for input into the field; display is controlled by format.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date formats 1
Format Current Date 3
Properties - Format, Input Mask, Validation Rule 5
Stumped By Dates 4
WHats wrong with this query? 4
date format 3
Mail Merge Date Format 9
Syntax Error 4

Top