Visibility and Hide a field based on value list selection.

[cap.zadi]

Hi

A help required.


I have a field sourced by value list named "Status" on form with values "Active or Suspended".

There is another field "SuspendedDate" to be visible only if above selected value is "Suspended" otherwise always hidden.



Note: "Active" is default data field value.


Regards

[isladogs]

If you have a single form, you could add this to Form Current event

If Me.Status = "Suspended" Then
Me.SuspendedDate.Visible=True
Else
Me.SuspendedDate=False
End If

Alternatively, use a Select Case statement

[cap.zadi]

Hi

Thanks for the efforts.