Object name in string

[john_murphy]

I have a string with my text box name in it ie
dim mystring as string
mystring = "text1"
how to I change a proprrty using only the string

ie
mystring.text = "hello"
help please
john_m_murphy@hotmail.com


------------------
Slan

[baroberts]

It might be done by referencing the Fields collection of the form. If you iterate through the Fields collection to find your target field by name you should have access to all of the properties of the object.

[Mark Sreeves]

I wanted to do something simular some time ago because i wanted to map database field names to controls

This works, but does it do waht you want

Dim mystring As Object
Dim MyObject As Control

For Each MyObject In Form1.Controls
If MyObject.Name = "Text1" Then
Set mystring = MyObject
Exit For
End If
Next

mystring.Text = "hello"