Setvalue Access 2000

[rbrule]

Hello,
I have a report that shows dollar amounts for each month of the year. I want to make the month fields visible only when the field is not null. I understand that Access 2000 requires VBA code to setvalue, instead of a macro. I tried setting up a macro, but it did not work. I then converted the macro to VBA and it still did not work.

Perhaps I should start from scratch. Could someone give me a sample procedure for making my month fields visible only when the field is not null?

Thank you
Ron

 

[spacepro]

Try something like this:

If IsNull(me.fieldname) Then
me.fieldname.visible = false
Else
me.fieldname.visible = true
End If

Andy

 

[rbrule]

Thank you Andy, It worked perfectly.

rbrule