Steve Schapel
miscellany at mvps.org
Fri Sep 7 16:03:40 CDT 2007
Happy to help, John. :-) This of course adds a lot of power to Conditional Formatting, because it means you can easily construct more complex or precise conditions involving the testing of multiple values, from fields or returned by functions. Regards Steve Eget, John wrote: > Thanks, I did not even know of capability!!!!! > > > ----- Original Message ----- > From: "Steve Schapel" <miscellany at mvps.org> > To: "John Eget" <joeget at vgernet.net> > Sent: Friday, September 07, 2007 5:29 AM > Subject: Re: [AccessD] Conditional Formatting with date > > >> John, >> >> You just select "Expression Is" in the first combobox in the > Conditional >> Formatting dialog, and then type the entire expression similar to my >> earlier reply, into the textbox. >> >> Regards >> Steve >> >> >> John Eget wrote: >>> Steve >>> >>> You have the need correctly, I was trying to utilize the Conditional >>> Format pulldown so that future changes could be made by other >>> individuals. >>> I am not sure where the expression would go at the moment. Will try > as >>> soon as I get to work within a few hours >>> Thank you so much for the response >>> > > >