Changing Date to Just month and Year

  • Thread starter Thread starter Bryce
  • Start date Start date
B

Bryce

I have a field that contains dates. I only want the
report to show the month and year. Can i do this on an
input mask? Thanks in advance for any help.

example. Field has 12/31/2003, and I want December 2003
 
Use Format.

=Format([DateField], "mmmm yyyy") for the control source
or, in the Format tab set the Format option to
mmmm yyyy

The first option won't work if the textbox has the same name as the field.
If it does change the name of the textbox to txtDateField. Make sure that
"auto correct" doesn't change the name of the field in the entry when you
change the name of the textbox.
 
Back
Top