Assigning Values

  • Thread starter Thread starter Gary Robinson
  • Start date Start date
G

Gary Robinson

Hi All

I have a question, i have a form with loads of text boxes on it, i have some
code that will be used for each textbox in a sepertae sub procedure. The
question i have is, can i specify in a string which textbox is to be
altered. I can do this normally by typing in each one seperatley, but i'm
looking for an easier way. Hope this makes sense.

Thanks in advance


Gary
 
can i specify in a string which textbox is to be
altered.
Click to expand...

strControlName = "txtAlpha"


Set ctlMyControl = Me.Controls(strControlName)


Me.Controls(strControlName).BackColor = vbRed



etc


Hope that helps


Tim F
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
set properties of a passed textbox name 3
Access 2 Digit year in Access Text Box 3
making check boxes into an array 1
Splitting control source value string in report 7
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Assigning a VBA result in a Report to a field in a Table 5
Update a Textbox on a Form with Field Value via VB. 6

Back
Top