2007 Macro conditions

[John]

Hi,
I have used a condition to make a label red if the value is null
Condition: "IsNull([RegistrationDate])"
Action: "SetProperty"
Arguments: "Label233, ForeColor, 255"

this works fine but does not change back to the orginal label color if there
is a date in the field [RegistrationDate].
Does anyone know the condition for the opposite i.e.
IsNotNull([RegistrationDate]) or how do I reset the label color if the
condition is false.

Regards

John

 

[John]

Guys,
I have managed to solve the first part of this question but now I have a
second problem.
The font color is set to a RGB value but was originally a Hex Value.
How do I set this back to a Hex Value if the condition is met?
Hex Color value is #56769D
Regards

John

 

[John]

Guys,
Managed to solve that too.
you need to put =RGB(100,20,15) in the value field of the macro.

Regards

John

Guys,
I have managed to solve the first part of this question but now I have a
second problem.
The font color is set to a RGB value but was originally a Hex Value.
How do I set this back to a Hex Value if the condition is met?
Hex Color value is #56769D
Regards

John

Hi,
I have used a condition to make a label red if the value is null
Condition: "IsNull([RegistrationDate])"
Action: "SetProperty"
Arguments: "Label233, ForeColor, 255"

this works fine but does not change back to the orginal label color if
there is a date in the field [RegistrationDate].
Does anyone know the condition for the opposite i.e.
IsNotNull([RegistrationDate]) or how do I reset the label color if the
condition is false.

Regards

John