If Email is blank formula help

Question

I am trying to highlight the email address field in reports if it is blank.&nbsp; I have tried
If(IsNull([Email]), "#ffffba"))&nbsp; but it is not working, I am getting a syntax error.&nbsp; Do I need to convert the field to a text field 1st and then use the formula?

Any suggestions??------------------------------Kelly Lyons------------------------------

chayceduncan · Answer

Email is treated like text so:&nbsp;
if( Trim([Email]) = "", "ffffba", "")

Trim just helps make sure you don't have any misleading spaces------------------------------Chayce Duncan------------------------------

Forum Discussion

If Email is blank formula help

1 Reply