User defined date format

[DM]

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. 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