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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Required Fields 7
Access Remove rows based on multiple fields 2
Access MS Access Required Fields 0
Canoscan FS4000US IR/FARE Problem 1
Access Dcount (multiple criteria) 3
Macro to Fill Down, or Fill Right 4
If statements that depend on multiple fields 2
Make labels visible/invisible when a text field is filled in/chang 5

Back
Top