Hide empty table row in report

[hanarina]

Hi..

I need help with this problem.
I tried;

If subject.value = "" Then
Subject.Visible = False
End IF

but it didn't work~
Tq...

 

[Alansidman]

Do your really mean to use "". That means an empty string or do you want the control to not be visible if the control is Null. There is a difference in Access.
Try

Is isNull(subject.value) then ....

 

[hanarina]

Do your really mean to use "". That means an empty string or do you want the control to not be visible if the control is Null. There is a difference in Access.
Try

Is isNull(subject.value) then ....

I tried this code and the entire subject column is hidden. How to make empty row only to be hidden?

 

[Alansidman]

Are you using a continuous form? Looks like it might be.

Look here: http://www.access-programmers.co.uk/forums/showthread.php?t=215308