I am using Access 2003
I want to created a field in a Db design that only shows me the month and
year.
What is the input mask I use to get only the month and year displayed.
aurora
Input masks aren't suitable for this: all they can do is constrain
what keystrokes the user can enter into a field.
If you use a Date/Time field, it must always contain a complete data
(a specific point in time); you can set its Format property to mm/yyyy
to display 02/2007, but it will actually need a day as well.
A Text field can contain anything you like - e.g. the text string
"02/07"; you can use an input mask "00/00" to force the entry of two
numeric digits, a slash (which will be automatically filled in), and
two more digits. That won't prevent the user from entering nonsense
values such as 83/55 though, and the text string will not be
interpreted by Access as a date, will not sort chronologically, etc.
John W. Vinson [MVP]
