Hide column when no data

[Muaz]

Hi,

I have a report in access having multiple columns. because of multiple columns it is not possible to display it in A4 size.

I want to hide the column when there is no data, Is there any possibility to hide column on the basis of criteria ?

Regards
Muaz

 

[Ranman256]

in the ON PRINT event

txtBox.visible = not isnull(txtBox)

 

[vbaInet]

Ranman256 provided you with a useful lined of code that should do what you're asking for but this will leave a void in the report. So can you clarify if you're trying to hide an entire field that has no data in the entire recordset, hide a control when it's Null or hide blank rows?

Perhaps you can show us a screenshow of what you're talking about?