If statement in macro using Is Null

Topic

New Reply

This If statement in my macro does not work.

If [FechaPagada] Is Null Then

This is in a text box in a form. When I open the form, a pop-up asks to define the part after the If.

I am trying to change a value depending on whether [FechaPagada] has a value or not.

Can you help, please?

Reply | Quote

Replies

Try testing for a non zero value instead.
If [FechaPagada] < 1 Then

cheers, Paul

Reply | Quote

Is that the way to test for Null in macros?
In VBA it is:
If IsNull([FechaPagada]) Then

Reply | Quote

I used another field to test, a yes/no field, and the inmediate if. Testing for a -1 or 0 works.

Is Patt´s point valid? Did I structure the original statement correctly?

Thank you all.

Reply | Quote