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
 

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

run a code based on the field conditional formatting back color 3
Change Required Field Property in Table 4
Conditional Formatting - I just don't see what I'm doing wrong. 3
Setting a value to a different field based on current field 1
Stay at field 2
color coding values 1
default value for one field based on another 2
Excel conditional formatting with Weeknum 4

Back
Top