I have an expression in the control source of the text box that reads =DateAdd("y",+181,[records review]) what I also want it to do is not show the null fields how can I do this?
I had difficulty in re-creating your problem, but the following code might work:
Use the 'On Format' event of your Report's detail section:
----------------------------------------------------------
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(MyDate) = True Then
MyDate.Visible = False
Else
MyDate.Visible = True
End If
End Sub
----------------------------------------------------------
Forgive me but I'm new to this. What I should have explained is that I have a report that I don't want any records that have null information in a particular field to show on the report. The report looks like this in the detail section;
The report is not link to a query other than the expression in [tdyreturn] control source and it reads like =DateAdd("y",[TDY Length],[TDYDri])
I don't want the report to show any record that is missing a date in the [tdydri] section. Hopefully I explained myself better.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.