Deactivate field based on other field value

  • Thread starter Thread starter injanib
  • Start date Start date
I

injanib

What I need to do is have some of the fields on the form deactivated (grayed
out) untill the value in the preceding field is a certain value or text. I
can't use conditional formating because I would need to use the values in the
object fields to be the conditions. In this case I need a the value of a
different field to be the condition.

What is the best way to do this.

Thanks in advance.
 
YOu could place code in the before or after update to enable and disable the
controls.

I would have one function that updates all the forms controls and have each
of the other controls call the one funtion. That way if a user goes back you
can update all the controls in one place.
 
injanib said:
What I need to do is have some of the fields on the form deactivated (grayed
out) untill the value in the preceding field is a certain value or text. I
can't use conditional formating because I would need to use the values in the
object fields to be the conditions. In this case I need a the value of a
different field to be the condition.

What is the best way to do this.
Click to expand...


Use Conditional Formatting with the Expression Is: option.

[other control] = certainvalue OR Not IsNumeric([other
control])
 
Thanks,

in the form I have a field called "RSA Type" which is a combo box with three
options (NCN, Temp, RSA). I want to following fields to be activated only if
the "Temp" is selected in the "RSA Type" field.

Can you tell me what the expression should be in the conditional formating.
 
injanib said:
in the form I have a field called "RSA Type" which is a combo box with three
options (NCN, Temp, RSA). I want to following fields to be activated only if
the "Temp" is selected in the "RSA Type" field.

Can you tell me what the expression should be in the conditional formating.
Click to expand...


For each of the text box controls that you want enabled:

Set the CF Default Format's enabled property to disabled.

Set the CF Condition 1 to:
[RSA Type] = "Temp"
and the enabled property to Enabled
 
Back
Top