Question

  • Thread starter Thread starter Tonyaa
  • Start date Start date
T

Tonyaa

Does anyone know how to have only certain fields display on a for
depending on a condition of another field? I have a field that has on
of two choices. I only want the three fields under this field t
display on the form if a condition is true on the other field. Pleas
advise and thanks to all that respond
 
Tonyaa,

The easy way is to use conditional formatting on the particular fields;
while in form design select the fields in question and go Formt >
Conditional Formatting, change the first drop-down to expresiion and type in
something like [FieldName] = value (if numeric), or [FiledName] = "value"(if
text), where FieldName is the neame of the field depending on the value of
which you want the others to appear or not. Finally, click the rightmost
icon (disable control) and then OK. Note that this will not actually hide
your controls, it will just grey them out and disable them, but it's
probably OK for the purpose.
To completely hide them you would have to resort to some VB code.
Interested?

HTH,
Nikos
 
Back
Top