hid empty field on report

[Theseekers]

Hi there,

I have a report which pull data out from a single table. Some of the fields might not have data in it so I would like to hide that field and move the field below it to its place. I have no idea how to approach this, can someone please give me some hints on how to get going with this.

For example:
dataset has last name, first name, address, address1, city, state, and zip

some will have address and address1 but most will not have address1 so I would like my final report display as such

Smith John
1234 Apple street
apt.123
New York, NY 222222

Smith John III
444 Elm Street
New York, NY 22222

so as you can see the second record does not have address1 and instead of having a blank space I would like to move it up..

Help please...

 

[PHV]

You may play with the CanGrow and CanShrink properties of the textboxes.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886