Conditional Formatting

mdr0906

Registered User.
Local time
Today, 18:50
Joined
Oct 9, 2007
Messages
15
Hi,

I would like to perform a conditional formatting in a form and would like your help.

I currently have a form where users enter in data. To aid them in identifying the fields they would complete, I am interested in using a conditional formatting.

For instance, if a user would select "Yes" on field A, then the field B's back color would change to white, thus the user completes field B. If the user selects "No" on field A, then the field B's back color would remain gray. Moreover, the user would not complete field B.

Hope this makes sense.

I tried writing the following and received an error message:

Condition 1:
Expression is =IIf([Application Form Sent?]="Yes",TRUE,FALSE)

The error message included:

"The expression you entered contains invalid syntax."

Could you suggest an expression that I use in this instance? Or do you recommend an alternative way to conditional formatting, such as "Field has focus"?

I appreciate your help.

mdr0906
 
The easiest way is to write some VBA code.

I.E. You can enable text boxes depending on the result of a dropdown box. The VBA could be triggered when you change the dropbox. I assume you haven't worked with VBA before?
 
Thank you for your response.

You are right. I am not familiar with VBA. Any sample codes that you could share? Or sites that I could use as a resource?

mdr0906
 

Users who are viewing this thread

Back
Top Bottom