Clearing Checkboxes on a form / Intellisense Issue

[RLN]

Re: Access 2003

I found a method here in the newsgroup that works for clearing
checkboxes, but don't understand a particular line of code and how it
works.

Here is the code:
1. Dim ctrl As Control
2. For Each ctrl In Me.Controls
3. 'uncheck all of the checkboxes...
4. If ctrl.ControlType = acCheckBox Then
5. ctrl.Value = False
6. End If
7. Next
8. End Sub

When I type the word "ctrl." on line 4, intellisense comes up and
presents a list containing
"Application, Column, Controls, Dropdown, Form.....etc..)
The only "C" options in intellisense are "Column" and "Controls".
"ControlType" is not presented in intellisense as an option. Why? Had
I not found this 8 line snippet of code here in the newsgroup, I would
have never would have ever guessed to try "ControlType" to get this to
work!

How many more of these are "hidden" from Intellisense and how can I
find them so that I don't waste uneccessary time hunting for a code
snippet when those options should have been in the intellisense?

Are there settings for the intellisense feature that can be tweaked so
I can see the true correct options when I type objects that are
"Dimmed" properly?

Thanks.

[RoyVidar]

"RLN" <rl***************@yahoo.comwrote in message
<11*********************@m73g2000cwd.googlegroups. com>:

Re: Access 2003

I found a method here in the newsgroup that works for clearing
checkboxes, but don't understand a particular line of code and how it
works.

Here is the code:
1. Dim ctrl As Control
2. For Each ctrl In Me.Controls
3. 'uncheck all of the checkboxes...
4. If ctrl.ControlType = acCheckBox Then
5. ctrl.Value = False
6. End If
7. Next
8. End Sub

When I type the word "ctrl." on line 4, intellisense comes up and
presents a list containing
"Application, Column, Controls, Dropdown, Form.....etc..)
The only "C" options in intellisense are "Column" and "Controls".
"ControlType" is not presented in intellisense as an option. Why?
Had I not found this 8 line snippet of code here in the newsgroup, I
would have never would have ever guessed to try "ControlType" to get
this to work!

How many more of these are "hidden" from Intellisense and how can I
find them so that I don't waste uneccessary time hunting for a code
snippet when those options should have been in the intellisense?

Are there settings for the intellisense feature that can be tweaked
so I can see the true correct options when I type objects that are
"Dimmed" properly?

Thanks.

Control is a "generic" type, which can be assigned all the different
types of controls. This is probably why the intellisence won't list
all the properties (of the controls we would wish it to do?).

If you check out the help file for the control types you wish to
manipulate (for instance, type TextBox, then hit F1), then check
out the Properties link.

Also for instance by declaring a variable as an explicit controltype

Dim x As TextBox

you can investigate the properties of this varible, which in this
case means properties of an Access Textbox.

--
Roy-Vidar