Report Labels are Not disappearing or appearing 1

[rokerij]

I have a report in Office XP that does part of the job for me but seems to hang on other parts. The problem is I have three text fields with 3 separate labels:

lbl53 Text Box (PerformanceTarget1)
lbl54 Text Box (PerformanceTarget2)
lbl55 Text Box (PerformanceTarget3)

If IsNull(Me.PerformanceTarget1) Then
Me.Label53.Visible = False
Else
Me.Label53.Visible = True
End If

The code will set the lbl53 visible property to false, but will not allow it to become true again when the text box is no longer a null value, i.e. has writing in it. I have set the text field in the original table to have a default value of 'Null'. I have tried to place the code in the Report_Open portion, with no results, I then moved it to the Report_OnActivate portion, with the limited result of having the label disappear but not appear when necessary. Any ideas?

Second issue, same report

My header for certain records in the report will drop down on the layout screen when I go to the preview screen. The first one looks great, header placed where needed, hit the 'Next' arrow to see the next "report" and the header falls 2 inches lower on the page. ? perplexing! Thanks in advance to all that take the time to read my post!



S.C. Albertin
Database Administrator/Newbie Tech
United Way

Help me to find my way, so that I may help others find theirs...

 

[rokerij]

Got the labels to disappear!
Created A sub with the coding to make them appear/disappear.
Went to Detail_Format called the sub, and it worked! Not sure why, but VB can strange like that. Still having issues with the header dropping.

S.C. Albertin
Database Administrator/Newbie Tech
United Way

Help me to find my way, so that I may help others find theirs...

 

[Betsvigi9]

Cheers rokerij. You have just solved a problem that was causing me to tear my hair out.