| | |
|
|
|
Question |
|---|
| message from Tonyaa on 19 May 2004 |
Does anyone know how to have only certain fields display on a form
depending on a condition of another field? I have a field that has one
of two choices. I only want the three fields under this field to
display on the form if a condition is true on the other field. Please
advise and thanks to all that respond.
|
| Nikos Yannacopoulos replied to Tonyaa on 20 May 2004 |
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
"Tonyaa" <Tonyaa.16jga0@nospam.MSAccessForum.com> wrote in message
news:Tonyaa.16jga0@nospam.MSAccessForum.com...
|
|
Archived message: Question (MS Access)
