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 |
|
bkana
Starting Member
18 Posts |
 Posted - 2007-01-19 : 10:58:10
|
| I have a number of text boxes (one on top of the other) to display the addresses in my report. I have Address_name, Address1, Address2, Address_city, Address_State, Address_PostalCode - Each with its own text box except for the city, state, and postal code for which I just combined the fields. However, I have many who do not have any data for Address2 and don't want an empty line in the address. Is there an expression I can use to display the next line or move/shift up the remaining parts of the address? Would the iif and isnothing expressions be helpful, and if so, how do I write it correctly?Regards,Bill |
|
|
ARC
Starting Member
10 Posts |
Posted - 2007-01-26 : 09:27:48
|
| not sure if it will work with text boxes, but you can set the visability of rows in a table control so that it will only show if there is a value to supply. Have a dig through teh help files for the details of how to make it work |
 |
|
|
|
|
|
Address fileds and iif isNothing statement