If Form Field is not null then...

[cotri]

I have a field called [Warning] in a form that I want to simply populate with the word “NOT” under a particular condition. That condition being if a field called [Model] is “Not Null” -AND- a field called [Year] is “NULL” then the [Warning] field will be the word “NOT”. I tried putting an expression together in the “Control Source” for the [Warning] field but was getting errors. Thanks

[RuralGuy]

Try using "Not IsNull([YourField])" in your expression instead of "Not Null".

[MAF4Fam6]

You could try a Condition Macro.
I use Access 2007, but I am almost sure this works in Access 2000.
Here's a pic of the Macro in Access 2007:

Attachment 513

Just change the field names and add the Macro to the On Current event of your form's Property Sheet.

-RC

[cotri]

Try using "Not IsNull([YourField])" in your expression instead of "Not Null".

Thanks, that worked great

[RuralGuy]

Glad we could help. Are you ready to mark this thread as Solved?

[cotri]

Glad we could help. Are you ready to mark this thread as Solved?

Will do...Thanks again