Custom date formats

[computertutor]

Is it possible to create a custom date format in Access to display only the month and date i.e. mm/dd on a report or form?

 

[Russell Hauf]

Sure. Just use the Format function. Say your date field is named fldDate. In the Control Source property of the control you want the date in (i.e., a TextBox), put:

• =Format([fldDate],"mm/dd")

Hope this helps,

Russell

 

[computertutor]

Thank you - that was easier than I thought it would be!

 

[bat17]

The format function is fine for a report where you just want to see the date but in a form it will prevent data entry. If you use the Format field on the properties sheet for the control then you can either select a preset format from the list or just type in the custom format that you want to use.

HTh

Peter