What's up with my code!? Need to BLANK a text box based on a NULL value of another one

[AccessForumUser]

hello,

I have a date range query which runs fantastic on my report.
Now, I have a field called "CaseNum" with a data type Short Text, and another field called "OtherNotes" which is a Short Text data type as well.
In my "On Load" located in the report, I have the following code:

If IsNull(Me.OtherNotes) = True Then
Me.CaseNum.Visible = False
Else
Me.CaseNum.Visible = True
End If

- So i'm saying, if OtherNotes is blank, then blank out the CaseNum which it's doing, but it's also blanking out the results that have OtherNotes as well..

What I'd like to do is if there is NO notes entered in the OtherNotes field, then do NOT show the CaseNum.

On my report I've got the CaseNum and OtherNotes Label in the "Page Header" area, and the text boxes for both in the "detail" section, so it shows up in a nice column when displayed.

The problem i'm seeing is that there are blank CaseNum when there are populated OtherNotes..


The other problem is that lets say there was 15 records during the data range search.. I get 15 lines on my report regardless if there is anything in them.

Help!!! - Thanks!

If i change the first line to "If Me.OtherNotes = "" Then", I get all the CaseNum populated.,
I also checked the Can Shrink and changed it to Yes

[Gicu]

Why do all that on the report and not simply move it to the query :CaseNum: iif(isnull([OtherNotes]),Null,[CaseNum])

Cheers,
Vlad

[CJ_London]

- So i'm saying, if OtherNotes is blank, then blank out the CaseNum which it's doing, but it's also blanking out the results that have OtherNotes as well..

learn about the order of events. The load event is performed once, so your code is only working on the first record.

you need to use an event (probably the format event) in the section where your controls are located

[AccessForumUser]

Amazing! Thanks for your help Vlad. And thanks to everyone who takes the time to read and help others out on this forum. I am truly grateful.
I never thought to look at it that way.. thanks again

[Gicu]

Glad it worked. Please mark the thread as solved if you think we are done here.
Vlad