control appearance of one control based on another

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

Is it possible to make a control visible based on another
control?

I have an option group with yes & no as its options (in
radial buttons)and a date completed text field.

Would it be possible to have the date completed field show
up ONLY if
the "yes" option is chosen?
 
Is it possible to make a control visible based on another
control?

I have an option group with yes & no as its options (in
radial buttons)and a date completed text field.

Would it be possible to have the date completed field show
up ONLY if
the "yes" option is chosen?
Click to expand...

Where? In a Report? On a Form?
The event to code depends upon where.
In a Report, the Section Format event that the OptionControl is placed
in.
On a Form, code both the Form's Current event and the OptionGroup
After Update event.

Code the event:
[DateCompleted].Visible = OptionGroupName = 1

Assumes the OptionGroup value for "Yes" is 1.
Change it as needed.

If the only options are Yes or No, perhaps you would be better off
using a simple Check box field instead of the Option group.
 
It's on a form
-----Original Message-----
Is it possible to make a control visible based on another
control?

I have an option group with yes & no as its options (in
radial buttons)and a date completed text field.

Would it be possible to have the date completed field show
up ONLY if
the "yes" option is chosen?
Click to expand...

Where? In a Report? On a Form?
The event to code depends upon where.
In a Report, the Section Format event that the OptionControl is placed
in.
On a Form, code both the Form's Current event and the OptionGroup
After Update event.

Code the event:
[DateCompleted].Visible = OptionGroupName = 1

Assumes the OptionGroup value for "Yes" is 1.
Change it as needed.

If the only options are Yes or No, perhaps you would be better off
using a simple Check box field instead of the Option group.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top