When Generating Report don't show columns which are empty

  • Thread starter Thread starter billy_pit
  • Start date Start date
B

billy_pit

Hi,
I have project in MS access.
In that project I am generating some reports for my company.
Now In my form I have one combobox(PalletNo_combo)
when I select an item from combobox and then click on search button then it will generate Report on search criteria.
Now in that report I have 15-20 fields like
Click to expand...
PalletNo,OrderDate,CustmerCode,ShippingLocation,Ca
rtons,PartialCartons,ShippedDate,TotalQuantity,Shi ppedQuantity etc
Now when Report gnerated I have column PartialCarton which is empty sometimes bcz of Null value inside it.
So I don't want to show it in report when whole column in empty or value is Null.
If anyone have solution plz help me.
Click to expand...
Thanks
 
If the whole column has null values, what is displaying on your report? Null
doesn't display anything. Do you want to hide the column label from a report
or group header section?
 
If the whole column has null values, what is displaying on your report? Null
doesn't display anything. Do you want to hide the column label from a report
or group header section?
Click to expand...

If the whole column has null values then it will displaying balnk
column on report.ya so i want to hide that column and its lable also.
 
In a report or group header you can use a text box with a control source like:
=IIf(Count([Possibly Null Column])=0,Null,"Column Title")
 
Back
Top