Format () question

[Laurel]

I'm trying to get a date to display in this fashion:
Wednesday, Nov 14 (or Wednesday, November 14 if I must).

If I use this format "dddddd\,mmm dd" I get this strange result:

Wednesday, November 14,2007,Nov 14

If I use this format "ddddd\,mmm dd" (dropping one 'd'), I get this result:

11/14/2007,Nov 14

Very strange. Is there a way to get what I want with the Format(,)
function?

 

[Ken Snell \(MVP\)]

Try this:

Format([FieldNameHere], "dddd\, mmm d")

 

[Ken Snell \(MVP\)]

Or, if you're using the Format property of a textbox in the report:

dddd, mmm dd

 

[Duane Hookom]

You should leave the control source with just the date field and set the
format property to
dddd, mmm d

 

[Klatuu]

In the format property of the text box to which the data is bound, select
"Long Date"

 

[Laurel]

Thanks to all!!!