Displaying and fields on field changes

[rjstewart]

Private Sub ACActivationType_Change()
If Form.frmFieldTrigger.ACActivationType.Value = "Field Value Modified" Then
Form.frmFieldTrigger.ACTtriggerFieldID.Visible = True
Form.frmFieldTrigger.ACTMilestone.Visible = False
Else
Form.frmFieldTrigger.ACTtriggerFieldID.Visible = False
Form.frmFieldTrigger.ACTMilestone.Visible = False
End If
End Sub

What I am trying to accomplish is to show a field or hide a field if the values dont equal whats listed.

[June7]

What is the issue? Are you doing this on a form in continuous or datasheet view? This code won't work nice with those because setting property of control affects all instances of control, every record will reflect the setting.

[rjstewart]

on a form.also the fields are found in the same table of records. i only want to display one or multiple items on the form. If the meet the requirements stated?

[June7]

Again: Is the form in continuous or datasheet? Controls are in detail section? Code won't work satisfactorily.

However, can use Conditional Formatting to Enable/Disable textbox or to change colors.