my iff statement only shows the now() function

[rainbows]

hi ,

=IIf([Invoice paid] Is Null, "hello",Now())
this is what i put into my form but no matter if i tick the invoice paid button or not it only shows the date i want tot to be empty until i tick the box the dispaly the date i did that .

thanks
steve

 

[theDBguy]

Hi Steve,

Checkboxes in Access cannot contain Nulls. They're either True or False. Try changing your expression to:

=IIf([Invoice paid]=False,"hello",Now())

Hope that helps...

 

[rainbows]

Thats great thank you

 

[Gasman]

Or =IIf([Invoice paid], Now(),"hello") which is how I like to code the logic?

 

[CJ_London]

For future reference’Is null’ only works in sql. In forms, vba you need to use the isnull function

 

[theDBguy]

Thats great thank you

Glad we could assist. Good luck with your project.