Need Date Input mask for month/year

[bkf7911]

Trying to find a date input mask that will display month year as mmm/yyyy. Example: "Mar-2007". Any help is greatly appreciated.

 

[RuralGuy]

I believe you can display it as you describe with:
Format([YourDate],"mmm-yyyy")

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[missinglinq]

An Input Mask of LLL"-"0000 will do the job you're looking for, but this format is unusual and will probably cause your users a lot of headache unless you have something visible on screen to let them know that this is what you expect.

RuralGuy's idea, used something like this

Private Sub YourDate_AfterUpdate()
  Me.YourDate = Format([YourDate], "mmm-yyyy")
End Sub

is probably the best approach. Your users can enter the date as they wish and you'll still get the results you want.

Good Luck!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!