multiple conditionally visible fields

[KWarzala]

Hello,



I have a form with 5 fields (date, time, person, area, location) and a button to assign a case number.

Before the person can get a case number, they must have all 5 fields filled out, if they don't, they get a message box asking them to fill out all the fields.

I'm trying to figure out code to make an arrow visible for each field that IsNull.

I tried:

If IsNull([date]) then
me.arrow1.visible = true
Else: me.arrow1.visible = false
end if
if IsNull([time]) then
me.arrow2.visible = true
Else: me.arrow2.visible = false
end if
etc..

I also tried:

If IsNull([date]) then
me.arrow1.visible = true
If IsNull([time]) then
me.arrow2.visible = true
(etc)
end if
end if

each time only the first arrow showed, any help on this would be greatly appreciated!

Thanks

[June7]

Looks like the first code should work but don't bother with If Then, just:

Me.arrow1.Visible = IsNull([date])

Me.arrow2.Visible = IsNull([time])

Consider using Conditional Formatting. If the field Is Null then show red back color.

[KWarzala]

wow, of course it was that simple!

Thank you, you saved me from hours of frustration