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 |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2005-08-01 : 11:42:20
|
| If I have the 10 textboxes in my footer with a value of "X" (from an IIF() expression), then I would like to alert the users and have the footer a different color.I'm trying to get the value of the textbox, but keep getting an error of it being undeclared. I'm trying different syntax, but can't get it to work.Here's the code:=IIF(textbox11 ="X" or textbox15="X" or textbox19="X" or textbox27="X" or textbox23 = "X" or textbox31 = "X" or textbox35 = "X" or textbox39 = "X" or textbox43 = "X" or textbox47 = "X","Gainsboro","Transparent") |
|
|
Fletch
Starting Member
29 Posts |
Posted - 2005-08-08 : 06:33:37
|
| Just a guess - you don't have line feeds in the expression do you? I have found that this can cause errors in long expressions, though it shouldn't. |
 |
|
|
bubberz
Constraint Violating Yak Guru
289 Posts |
Posted - 2005-08-08 : 10:06:20
|
| line feeds? What's that?Thanks for the reply? |
|
|
|
Bela
Starting Member
1 Post |
Posted - 2005-10-13 : 10:23:43
|
| Hi! RS are right. In an expression box, you cannot see directly your items... so they seem undeclared. You can refer to your items via the "ReportItems" global collection. For example, if you have a textbox that is called "textbox11", you can refer to its value in the following form:ReportItems!textbox11.Value |
|
|
|
|
|
|
Value of 10 textboxes to decide group footer color