Software

Ask something
Discussion Locked

A very dumb Access question

0 helpful
3 replies

by joeplaisted

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,
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

3 replies

by bristar

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.

This discussion is closed to new replies.