Access Table

[john]

In MS Access Table, how do you format the date to show only Month and Year only?

[ranman256]

no need to do it in the table, do it in query. but either way:

format([datefld],"yyyy-mm")

[john]

When a user enters the date it should be in MM/YY format. how can I change it?

[pbaldy]

MM/YY isn't a date, it's two thirds of a date. If they enter that, what day of the month is it? You wouldn't be able to enter directly into a date/time field with that format. You could let them enter that in an unbound textbox and parse it out, adding a day and using the DateSerial() function to make a complete date.

[davegri]

Very confusing. In post#1 you want to show only month and year.
In Post#3 you say the user enters month and year and you want to change it. To what?