Setting in/visible fields using VB

[jlrrush]

I am creating a report that is using a query, and would like to have certain fields visible depending on if a field is null or not. For example:

If var2 is not null, then var1 should be invisible and var2 should be visible. If var2 is null, then var1 should be visible and var2 should be invisible.

I am planning on putting the code in the "OnOpen" event of the report, but as of now I have been unable to get the focus to var2 to set the visible property to true or false.

 

[snyperx3]

Try using the OnFormat event for whatever section this field is in. (presumably Details).

If IsNull(var2) Then
var1.Properties("Visible") = True
var2.Properties("Visible") = False
Else
var1.Properties("Visible") = False
var2.Properties("Visible") = True
End If

-Pete

 

[jlrrush]

Thanks! That was perfect