When Generating Report don't show columns which are empty

[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

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.

Thanks

 

[Duane Hookom]

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?

 

[billy_pit]

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 then it will displaying balnk
column on report.ya so i want to hide that column and its lable also.

 

[Duane Hookom]

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")