I've got an invoice report all set up which works perfect, however, I'm now being asked to add an additional information line for each item on the invoice but only print it when it has been populated
The extra information field is the easy bit, I've done that and added it underneath the existing item description field on the report. I've used the following code to hide the extra info line if it is blank, however, the report then just leaves a gap in the print out for each item where the extra information line is blank.
How do I get the report to only print the additional information field if it is not blank and close the gap if it is blank?
As always, any help is greatly appreciated
The extra information field is the easy bit, I've done that and added it underneath the existing item description field on the report. I've used the following code to hide the extra info line if it is blank, however, the report then just leaves a gap in the print out for each item where the extra information line is blank.
How do I get the report to only print the additional information field if it is not blank and close the gap if it is blank?
Code:
if me.ItemAddInfo="" or isnull(ItemAddInfo) then
me.ItemAddInfo.visible = False
end if
As always, any help is greatly appreciated
