<div>
format([DateField],&quot;mm/yyy<wbr />y&quot;)
</div>


<div>
Where do I put that? &nbsp;P pasted it in the format line in the field properties and it turned out like: &nbsp;&quot;for&quot;m&quot;at([Pur&quot;ch\as\ed&quot;at<wbr />e],mm/yyyy<wbr />)&quot;
</div>


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)"

<div>
<div class="content wysiwyg-content">
I have a date field in a table and then on a form. &nbsp;But we want the field to display only the month and year.<br />
<br />
Like: &nbsp;06/2014 for example.<br />
<br />
How can I do that?
</div>
</div>


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?

How format date field to show month and year only

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.