Changing visibility at record level on a form based on a field value

[tuniwes]

This is beating me up, I want to change the visibility of an image and another field for each record on the form base on a numerical status field, could be 1,2 or 3
The problem is all records are reacting to the status in the first record not for each individual record

Private Sub Form_Current()


If Me.Status = 2 Then
Me.Image67.Visible = True
Me.Lockoutactive.Visible = True
Else
Me.Image67.Visible = False
Me.Lockoutactive.Visible = False
End If
End Sub

I have put the same code in the after update event
Where am I going wrong please

Thanks
Ian

[Missinglinq]

This type of code will only work for a Single View Form...Record-appropriate formatting for Continuous View or Datasheet View Forms has to be done using Conditional Formatting off of the ribbon, can only be done for some type of Controls, and is limited in the types of formatting available, Visibility not being one that is available.

What type of Form are we talking about, here?

Linq ;0)>

[tuniwes]

Ah, that explains it, I created it with the multiple items wizard

At least I wont waste any more time trying to do something that is not possible

Thanks for the prompt response

Best

Ian

[Shorty]

I also have a user requirement to loop through a Form to set a field to not be visible, based on te value of another field. Can you suggest a solution ? I am considering sending the data to Excel, where I now that can do this, but would like to avoid that. Thanks in advance !