I would like to activate the visibility of a header depending on the null value of a cell inside it

[cosette00]

Hi,

I have GroupHeader2 which has inside it the textbox student.

I would like all of groupheader2 to not show if student is null.

So I selected the 'on format' event for GroupHeader2 and entered the following code:

If student is null
then groupheader2.visible is false
else groupheader2.visible is true
endif

This is not working for me. Could someone shed some light as to why?

Thank you,

 

[dhookom]

Try use the following which assumes there is a text box in the section bound to the field Student:

Cancel = IsNull(Me.Student)

Duane
Hook'D on Access
MS Access MVP

 

[cosette00]

Thank you Duane.

 

[dhookom]

cosette00,
Can we assume it worked?

Duane
Hook'D on Access
MS Access MVP

 

[cosette00]

I haven't tested it yet, because the memo field became a huge problem and the headmaster had a panic attack. But the header is minimal at this point. I am sorry I should have clarified.

D.