Display controls of Data fields in access forms. (1 Viewer)

[Premlatha Raghunath]

I want to disable certain fields in the form upon selection of a particular check box option (which is also a data field). Is there any way to do it? Any help is appreciated.

 

[theDBguy]

Hi. There are a few ways to do it. What does the checkbox represent?

 

[pbaldy]

Welcome to AWF. I moved both of your threads out of the introductions forum to more appropriate forums. In the future, try to pick the appropriate forum to add a question to.

Here's one way:

http://www.baldyweb.com/ConditionalVisibility.htm

 

[Premlatha Raghunath]

Check Box represents the different types of projects carried out in the organization. Multiple options can be selected and based on the selections, I want to disable unnecessary fields in the form.

 

[theDBguy]

Check Box represents the different types of projects carried out in the organization. Multiple options can be selected and based on the selections, I want to disable unnecessary fields in the form.

Hi. So, to "disable" a control, there is an Enabled property. You set it to True if you want to enable a control and you set it to False if you want to disable it.

 

[Premlatha Raghunath]

Where can I find the property? I want to disable certain fields upon the selection of particular check box option and again the display options should change if I'm selecting another check box option.

 

[pbaldy]

Did you look at my link? Disabling would be

Me.TextboxName.Enabled = Whatever

 

[Uncle Gizmo]

Where can I find the property?

If you follow this link:- Run-time error 438 you will see the property sheet of a TextBox and the property sheet of a Label. The data tab for each control is showing. You can see that only the text-box has an Enabled Property. The Label does not have an Enabled Property.

 

[Gasman]

This has only recently been asked

https://www.access-programmers.co.uk/forums/showthread.php?t=306259