label caption

[eacollie]

Can I display the weekday in a label on a report? If so, how?

The record source for the report has a variable "StartDate" and I want to show the day of the week (Monday, Tuesday, etc) of this date in a label.

Thanks much

 

[Galaxiom]

Fake the label with a textbox. Then you can use a ControlSource formula to show the day.

Set the border to transparent, lock and disable and the textbox will look and behave like a label.

 

[eacollie]

StartDate is a field in the record source of the report.

I created a textbox and set the control source to =Weekday([StartDate],[vbSunday]) but it displays empty. What am I doing wrong?

 

[eacollie]

Got it. Thanks!