How format date field to show month and year only

I have a date field in a table and then on a form.  But we want the field to display only the month and year.

Like:  06/2014 for example.

How can I do that?
Who is Participating?
Gustav BrockConnect With a Mentor CIOCommented:
Don't use the Format function, just set the Format property of the textbox in the form.

Currently, it probably is set to Standard. Change that to: mm/yyyy

Rey Obrero (Capricorn1)Commented:
SteveL13Author Commented:
Where do I put that?  P pasted it in the format line in the field properties and it turned out like:  "for"m"at([Pur"ch\as\ed"ate],mm/yyyy)"
SteveL13Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.