Help with greying out a field

T

TD

I have a form that I want to be able to grey out Field #2 if the user
selects a value of true from Field #1. If the user selects a value of false
from Field #1, then I want that user to be able to make an entry in Field #2
(in orther words not be be greyed out.)
Can this be done?

Thanks,
TD
 
G

Graham Mandeno

Hi TD

Yes. In the AfterUpdate event procedure of Field1, put the following line
of code:

[Field2].Enabled = [Field1] <> False
 

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

Weigh tasks 0
How to Create an S-Curve from Custom Field? 0
Adding sequence numbers to paragraphs 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Word macro that can call cells out of Excel for a find and replace 0
Delete all data after a symbol in a field 0
Finding the right style field in VBA 0

Top