Visablity of feilds on continuious forum

[swingline]

I have a continuious form that I would like to change the visablity of one of the fields. Initatally I attempted to put this in on Load, but that sets every record to false on load if the dlookup is true. On current works, some what, meaning when I click on that record where the dlookup is true, then the visablity is set to false as exspected.

I guess my question is, how can a just change the visability for one record on a continuious form?

Private Sub Form_Current()
If DLookup("TaskNumber", "CompletedTask", "TaskNumber =" & [TaskNumber]) Then
Me.Iterations.Visible = False
Else
Me.Iterations.Visible = True
End If
End Sub

 

[Minty]

Conditional formatting is really the only route and you probably still need to get clever with hidden boxes and the current event.

 

[Ranman256]

in continuous form ALL boxes on EVERY RECORD w that name are visible (or not) at the same time.
you cant have 1 line visible and the next not.