iif Statement in Default Value

[travismp]

Is it possible to add an Iif Statement to a default value?

IIf([hours],"YES","NO")

This does not work?

 

[KenHigg]

Where are you trying to do this? At the table or form level? And '[hours]' doesn't make a lot of sense as an expression to evaluate...

 

[Scottyk537]

I don't think you can do this because an IIF statement is not a value.
I have done this before by adding code to the OnLoad event of the form.
Try adding your code there....... except you woulg write it like

If Me!Hours = 0 then 
me!OUTPUT = "YES"
Else
me!OUTPUT = "NO"
End if

 

[travismp]

I have not ever done this either. Someone else needed to know. I can make an update query to do the same thing. Thanks guys.