Visible Based on Multiple Fields

  • Thread starter Thread starter Ryis
  • Start date Start date
R

Ryis

Hello,

I am trying to make a field only visible if 8 other fields are filled in..I
have tried some If functions with no success, any help would be appreciated..

Ryan
 
MyControl.Visible = (Not IsNull(Control1) And Not IsNull(Control2) And...to
Control8)

..Visible will be True only if all are not null. If any of them could be
empty strings instead of null, you may want to substitute this: Not
IsNull(Nz(Control1,""))

Put this statement in the Form_Current and in the AfterUpdate event of each
of the 8 controls so that the main control will be made Visible/Invisible any
time any of them are updated.
 
Back
Top