I am using a report to produce a laden sheet which opens in design mode "On Click" of a command button. There are 3 columns, Quantity, Type and Model, all of the fields are lables thus enabling the quantity options to be different each time the report is printed, (without saving), the other lables contain the equipment details. To cover all options I have a lot of lables to cover all types of equipment, my question is:
What code can I use if the lable remains unfilled it will not be printed so I dont get a lot of empty boxes or spaces in between rows that do have data in them.
Thanks for time in advance
What code can I use if the lable remains unfilled it will not be printed so I dont get a lot of empty boxes or spaces in between rows that do have data in them.
Thanks for time in advance