Solved IF function for filtered data

[Kayleigh]

Hi there,
In my report I have textbox which should display the filter which the report was opened on. I would like to apply an IF function so if the report is not opened with filter ie all records, it will display 'all'. How would do I code this?
Thanks again!

 

[bob fitz]

In the reports On Load event:

    If Len(Me.Filter) > 0 Then
       Me.NameOfTextBox = Me.Filter
    Else
       Me.NameOfTextBox = "ALL"
    End If

Substitute NameOfTextBox with the actual name of your textbox control

 

[Ranman256]

if Isnull(Me.Filter) then

'but all filtering should be done outside the report.
on a form or query.

 

[Kayleigh]

Great I used that code with some tweaks!
Thanks