vba - If statement in MS Access Expression Builder on Control Source -
I have an unbound textbox on my form that I put on the control source but unbound field always = IIf ((date () - [edit]), = date () - [boundfield ] and it works fine gives me the number of days required, but I have to keep an I statement in this unbound field, so I want to use the expression builder typed on the control source.
= Iff (date () - [bound area]> 120, "max", "max not")
Display # names ? What error can I have on my code?
Comments
Post a Comment