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