Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
skalra
Starting Member
20 Posts |
 Posted - 2009-01-21 : 15:36:48
|
| Hi,I want to change the color of the textbox based on the dataset value when the date value is null or nothing.I am using the following code on the BG property of textbox but it is not changing the color for null values:=IIF(Datediff("yyyy",Fields!fieldname.value,Now())>1,"Red",iif(Datediff("yyyy",Fields!fieldname.value,Now())<1 OR Datediff("yyyy",Fields!fieldname.value,Now())= nothing,"Black","White"))the first two condition are working finr but when i am using for null values it is not working.Please helpRegards,Skalra |
|
|
revelator
Starting Member
32 Posts |
Posted - 2009-01-22 : 04:45:12
|
| Try this...=IIF(Datediff("yyyy",Fields!fieldname.value,Now())>1,"Red",iif(Datediff("yyyy",Fields!fieldname.value,Now())<1 OR IsNothing(Datediff("yyyy",Fields!fieldname.value,Now())),"Black","White"))-----------------------------------Waiting for the Great Leap Forwards |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
|
|
Change field color based on dataset value