General discussion


A very dumb Access question

By JoePlaisted ·
Sorry for this one, but I can't remember how do do this. I can't get my date/time field to change from standard short date to a date structure that allows only month and year entry (mm/yy). I have used the input mask wizard to create a new input mask and when I try to enter a date that is month and year only it gives me the month and 4th day of 2004 (example 1/4/2004) as the date. What am I doing wrong?

Thank you in advance for your help

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Bristar In reply to A very dumb Access questi ...

Input masks are kinda funny. The format field will allow you to view a full date as a mm/yy, but the input mask refers only to alpha and numeric characters. For the input mask, try using 99/99 and use the mm/yy in the format field.

Collapse -

by JoePlaisted In reply to

Poster rated this answer.

Collapse -

by JoePlaisted In reply to A very dumb Access questi ...

This question was closed by the author

Related Discussions

Related Forums