Report Question

[DLN]

As NeoPa just pointed out to me I should explain what I did in the solution.

I used and IIf statement in an unbound textbox to check the values in the controls which are set to invisible and print the required value only if set to yes. I then set the "Can Shrink" property on the text boxes to yes which will check for any null values in the unbound textboxes. This should avoid any spacing issues.

Thank you, this is very helpful.

[DLN]

The detail section is also set to Can Shrink = Yes.
Having gone through the question again and looked at this solution, I feel it's a good potential solution to your requirement. Let us know if this helps.

Yes it does help.

I would like to thank all of you for you help.

[MMcCarthy]

Thank you, this is very helpful.

You're welcome.