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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Glitched addressing, or just addressing controls incorrectly? 1
Run code then repeat every 15 minutes 3
time field 1
Record Insert via UnBound Controls 3
Windows Service Timer Woes 2
No Current Record 2
If Empty/null field, hide label (?) 2
Sum a field with null value 5

Back
Top