change to null value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report where I list drop off and pick up address and time. What I
want to do is if the pick up is equal to drop off than show pick up null. I
know it should be easy, but... well here is what I have so far
If Me.Time = Me.Time2 Then
Me.Time =
End If
Please help as I have tried me.Time = NULL, Me.Time = " ", nothing seems to
work.
 
Where is the code located? It should be in the Format event of the section
of the report your Time and Time2 controls are in. You could also do it in
the control source of Time: =IIf([Time] = [Time2],"",[Time")
 
Back
Top