No Data in field

[JohnSteven]

I have a report for Interoffice Memos and need a little help. The problem is in the "CC:" field, if there is no person to "CC:", how can I get the report to print without showing a blank "CC:" field??? What I would like to do is if there is nobody to "CC:", have both the label and text box not appear on the Report and bring the "Subject:" line up where the "CC:" line was. Got any ideas??????????

 

[Falcon99]

Possibly . . . try this.

Change label to textbox.
Set Label and Field texboxes to "CanShrink" = Yes

Use IIF to determine whether to display "CC:" or not.

=IIF(IsNull[CC:], "","CC:&quot

Theorectically if your field is blank the label will "shrink" along with the data field.

HTH
Falcon

 

[JohnSteven]

How is it possible to set a Label's properties "to shrink" or "to grow" as these are not options allowed a label????

 

[Dalain]

Change the Label to a text Field and make it look like a Label And Make Sure that you have no lines, boxes etc... on the same line as the [CC] field , else when the field shrink the report won't. Lines and Boexes do not shrink

IIF(IsNull[CC:], CCLabelName = "",CCLabelName = "CC:&quot


Pierre