looping controls has no value

[spinkung]

ahhhhghghhgghhh


why oh why is access messing with me.

i have this

            If Left(ctl.Name, 11) = "txt_SafeHaz" Then
            MsgBox ctl.Value
            MsgBox Me.txt_SafeHaz01.Value

basically i wat to loop through my controls. when i get to some with a prefix of called txt_SafeHaz... i want to put the value in an array.

so when i do msgbox ctl.value it comes out BLANK. NOT with a value.
when i do MsgBox Me.txt_SafeHaz01.Value it shows the value.

am i going mad or should this work.

 

[r.harrison]

Try using me.controls(ctl.name) instead.

 

[spinkung]

worked perfectly. thankyou.

 

[Galaxiom]

There must be something wrong with your loop.

Dim ctrl as Control
   For Each ctrl In Me
      If Left(ctrl.Name, 11) = whatever
         DoSomething
      End If
   Next

BTW Value is the default property so does not need to be explicit.