In my accounting application I managed to hide columns with the code below. It is columns or fields on the sub form, even though the code is placed on the main form. This is a form through which I capture payments.
Generally, reports display very similar than the forms. I want a field (cboComent_IDaj) on a sub report to display on a condition. The fields visibility is set to "no" on the sub report. I tried the following code without success.
The condition is in query q02PaymentsSub.BatchtypeA if the word "Salaries" or "Wages" is there, the field (cboComent_IDaj) must turn visible on the sub report.
I also tried the code below.
I put on some good time on the internet, no success yet.