criteria to show/hide box on continuous form

[tagteam]

I want to show or hide a box on a continuous form. If there is a date in the ShopOut field i want the label to show up , if not then it will not appear.



I am trying

If IsNull(Me!ShopOut) Then
Me.StillinShop.Visible = True
Else
Me.StillinShop.Visible = False
End If

however, it shows the box whether there is a date in ShopOut on not. Is it possible to do this in a continous form or do i need somekind of me.record#.ShopOut or something.

[tagteam]

I was able get this by using conditional formatting like this

IsNull([ShopOut])=True

IsNull([ShopOut])=False

And I just applied that to a blank field box

[June7]

This won't be possible on form in datasheet or continuous view if the box is in Detail section. Setting the Visible property will be applied on all instances of the box because there is really only one box. If this is a textbox or combobox, the best you can do is to disable or change color with Conditional Formatting.