Conditional Formatting


H

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
 
Ad

Advertisements

W

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
 
Ad

Advertisements

R

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
 

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