Long Date

[Emma]

Hi I was wondering if there's a way to make a long date but without the day
of the week ie June 18, 2009?

 

[fredg]

Hi I was wondering if there's a way to make a long date but without the day
of the week ie June 18, 2009?

Do you mean you wish to display the 6/18/2009 date as
June 2009?

Simply write
mmmm yyyy
on the control's Format property line.

If you mean to actually store the date without the day in a Date
datatype field, then no, you cannot. A date must have a month day and
year component.

 

[John Spencer (MVP)]

You need to use a custom format for that.

Replace Long Date with "mmmm d, yyyy" (include the quote marks)

"mmmm d, yyyy"

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Emma]

In the design view of the form, in the property sheet of the format I put
"mmm d, yyyy" But that's all that shows up no month or anything. Maybe I'm
not explaining it well, what I would like is the day ie "Sunday" not to show
up.

 

[John W. Vinson]

In the design view of the form, in the property sheet of the format I put
"mmm d, yyyy" But that's all that shows up no month or anything. Maybe I'm
not explaining it well, what I would like is the day ie "Sunday" not to show
up.

What do you mean by "the property sheet of the format"?

What John was suggesting is to open the Form in design view. Select the
textbox in which you are displaying this date field. Type

"mmmm d, yyyy"

just like that, quotes and all, into the Format property.

 

[Emma]

Sorry I figured it out "mmmm dd", "yyyy" works for me now