Is there a way to make the day's name show up automatically in a header?

[Marq]

I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top right corner of form when printed.

I'd also like to have the actual day's name show up automatically under the date. I tried putting below it &[DAY] but it didn't work.

any suggestions how to make this happen?

 

[Fluff]

Because as Mark said, it was concatenating the 2 with the first part of the date.

 

[Marq]

Because as Mark said, it was concatenating the 2 with the first part of the date.

aahhhhhh...I thought that was effecting the font size only...but I see what you are saying.

thanks for clearing it up for me.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Rick Rothstein]

How about

Me.PageSetup.RightHeader = "&""Arial,Bold""&21&D" & Chr(10) & Format(Weekday(Date), "dddd")

This will give 21pt typeface

You do not need the Weekday function call surrounding the Date function as this will work the same...

Format(Date, "dddd")