Conditional Formatting

[hfrupn]

Is it possible to have two conditional formats on one field with the
following criteria like this?
If a date field is, Less than or equal to – Date(), the field’s back colour
format is red, or if a tickbox in the same form is changed to true, then the
red format of the date field is overridden and the date field’s back colour
changes to grey. Also if the tickbox is false the first format applies.

Regards
Nick

 

[Wayne-I-M]

or if a tickbox in the same form is changed to true

Also if the tickbox is false the first format applies

These 2 condidtions will cancel each other out.

If the check box = -1 then do some
If the check box = 0 then do the same thing

??

You will need to look at what you the format to be and use something like

[CheckBoxName]=-1 And [DateControl]<=Date() make red

Then add a second condition such as

[DateControl]>Date() make grey

 

[Ron2006]

Do some research on Conditional Formating in the help system.

With that you can have three different conditional formats along with
you default format.

This will work for single and multiple and datasheet views whereas
specific code in the form oncurrent event has some limitations if you
are trying to do it on datasheet view.

Ron