Date Format in table

[Techdawgs]

I have a column in my table that just needs to show month and year. I have the format set up as mm/yy. I want to set it up that when you enter "7/7" (July/2007) it takes it as "07/07" and not "07/07/2005".

 

[dhookom]

I would probably never do this since date entry in computer programs is date entry is date entry. However, you could create code in the after update event like:

Me.txtYourDate = DateSerial(2000+Day(Me.txtYourDate), Month(Me.txtYourDate),1)

Set the format of the text box to only display the month and year.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]