Macro condition on day of the week

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
 
K

Ken Snell

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"
 
R

Rob

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
 
K

Ken Snell

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top