Formatting date to look like this: ex. (March 05, 2005)

[rgvstudent05]

I cannot find a way to format my dates like this: (March 05, 2005) for example. I have seen short date and long date but neither of them match what I need. Can someone explain to me how to format it so make it look like that. Do I have to create a custom mask or something??? PLease HELP! Thank You

 

[bmacr]

In the ControlSource of your text box, put:

=Format([YourDateField],"mmm dd, yyyy")

OR:

On the Format tab of the properties window, type mmm dd, yyyy for the Format Property.