cannot find 'value' in the properties colletcion...

[rocco]

Hello,
I have a form with many controls of different type.
I'm building a procedure to clean the value of any controls.
This is what I wrote:
---------
Dim ctl As Control
Dim i As Integer
For Each ctl In Me.Controls

For i = 0 To Me.Controls(ctl.name).Properties.Count - 1
If Me.Controls(ctl.name).Properties(i).Name = "Value" Then
ctl.Value = Null
Exit For
End If
Next
Next
-----------------
It runs...but doesn't do anything.
I checked it against a combobox and it has come out it never finds the value
property iterating the collection.
How could this happen?

Thanks,
Rocco

 

[Marshall Barton]

I have a form with many controls of different type.
I'm building a procedure to clean the value of any controls.
This is what I wrote:
---------
Dim ctl As Control
Dim i As Integer
For Each ctl In Me.Controls

For i = 0 To Me.Controls(ctl.name).Properties.Count - 1
If Me.Controls(ctl.name).Properties(i).Name = "Value" Then
ctl.Value = Null
Exit For
End If
Next
Next

If you have no way to identify which controls should be
reset, then a common way to do that is:

 

[Marshall Barton]

I have a form with many controls of different type.
I'm building a procedure to clean the value of any controls.
This is what I wrote:
---------
Dim ctl As Control
Dim i As Integer
For Each ctl In Me.Controls

For i = 0 To Me.Controls(ctl.name).Properties.Count - 1
If Me.Controls(ctl.name).Properties(i).Name = "Value" Then
ctl.Value = Null
Exit For
End If
Next
Next

Sorry if there was an incomplete reply.

Try using:

On Error Resume Next 'ignore ctl without Value
For Each ctl In Me.Controls
ctl.Value = Null
Next ctl

 

[rocco]

thank you,
that is what I have done.
i was just wondering why I cannot find 'value' in the properties collection.
Just trying to learn something...

 

[Marshall Barton]

i was just wondering why I cannot find 'value' in the properties collection.
Just trying to learn something...

Your guess is as good as mine. I suspect it's because the
property has no meaning until the form is loaded so it was
implemented as an internal property. (I have it from a
"reliable source" that there are a lot of internal
properties that we can not use at any time.)

 

[rocco]

Thanks you very much for this hint !!

Your guess is as good as mine. I suspect it's because the
property has no meaning until the form is loaded so it was
implemented as an internal property. (I have it from a
"reliable source" that there are a lot of internal
properties that we can not use at any time.)