Hide label when text box is empty 1

[EELungs]

In MS Access I have this report:

Student(Label): StudentName (Text Box)
----------------------------
School Name(Label): School(Text Box)
GPA (Label): GradeAverage (Text Box)

School Name(Label): School(Text Box)
GPA (Label): GradeAverage (Text Box)

So if the text box is empty on GradeAverage (second school) the GPA label will not print just for the second school

 

[JohnLowell]

in the Detail_Print event you would write so VBA code to check the GradeAverage text box. If the box is enpty, then GPA(Label) is made invisible.


if isnull(me.GradeAverage) or len(me.gradeaverage) = 0 then
me.GPA(Label).visible = false
else
me.gpa(Label).visible = true
endif

Let me know if this works.