If 2 conditions are met then

[aymanmb]

I am trying to write a code that will enable an event to happen if 2 conditions are true, something like:

If [DueDate] >= [CurrentDate] And [EndDate] is Null Then
Event ..... take place

I tried above and did not work

it works only if write one condition of above

how can I set it up correctly

 

[Moniker]

If ([DueDate] >= [CurrentDate] And Nz([EndDate],"") = "") Then

 

[aymanmb]

works great, thanks a lot

what if I want if above are met then [DueDate] color is red

how to write it

 

[KeithG]

If ([DueDate] >= [CurrentDate] And Nz([EndDate],"") = "") Then
.
.
.
Else
me.[control name].ForeColoer=[Color Number]

 

[aymanmb]

what is the color number to change the font to red

 

[KeithG]

I believe it is 255