Thanks for the assistance when I type in the code its telling me a field is required, where I have it in bold. else if (currentfieldvalue="" or IsNull(currentfieldvalue)) then crred.
Thanks for the assistance when I type in the code its telling me a field is required, where I have it in bold. else if (currentfieldvalue="" or IsNull(currentfieldvalue)) then crred.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 29 Sep 2015 at 5:03am
Null fields cannot be highlighted (back ground color changed).
You may need to create a formula field to use as your display field rather than the original field
example:
if ISNULL(table.field) then "" else table.field
place the above formula field onto the report canvas.
use a conditional background formula on it
if currentfieldvalue in ["tom","sallie"] then
craqua
else if currentfieldvalue="" then crred
else crnocolor
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum