Macro condition on day of the week

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I would like to have a condition for a macro which is
determinate on a field whose format is the day of the
week (dddd).

ie
[Forms]![PerformanceStatus]![DAY]="Monday"

but this doesn't work.

I would really appreciate some assistance on this.

Rob
 
The format of a date-formatted control has *no* effect on the value that is
in the control. The control contains the entire date, not just the day name.

Try this:
Format([Forms]![PerformanceStatus]![DAY], "mmmm")="Monday"
 
Thank you very much for your help. It works perfectly.

If you are ever in Glasgow, Scotland, there is a dinner
for two and two cinema tickets available for you and a
friend.

Regards,

Rob
 
Thanks for the offer....Scotland is a wee bit o' distance from Michigan, US!
But one never knows, eh??!!!
 
Back
Top