Format text box with long date

[data808]

I am trying to format a bound text box with the long date format in the property sheet. I also set the default value to "Date ()" so that it auto populates with today's date. I like the long date format except for the day of the week that is included with this format. Right now its showing as:

Tuesday, December 27, 2022

but I would like it to be shortened to:

December 27, 2022

Thanks.

[June7]

Try mmmm dd", "yyyy

However, users might encounter frustration when trying to edit this field. I would format on report but not on form.

[data808]

Try mmmm dd", "yyyy

However, users might encounter frustration when trying to edit this field. I would format on report but not on form.

Is there a way to do this in the property sheet under the default value? Or do I need to use VBA? Right now default value for this text box is:

Date ()

Would I be able to add something like this:

Date () mmmm dd", "yyyy

I actually tried it but it didn't work. Do I have to enclose it with quotations?

[June7]

Sorry, that is typed into Format property, NOT DefaultValue.

No quotation marks.

Works for me.

[data808]

Sorry, that is typed into Format property, NOT DefaultValue.

No quotation marks.

Works for me.

Awesome! Thanks very much June7. Worked like a charm.