Search results

Hello, I have 480 textboxes in my form. What I am looking to do, is that any time any of thest textboxes are clicked (or double clicked) I want to then get the name of that textbox saved into a variable. So I have created a public variable called tbName. What I need is this: - if the active...

For those interested. Got the answer Dim numberOfTextBoxes As Integer Dim textBoxName As String Dim i As Integer numberOfTextBoxes = 20 For i = 1 To numberOfTextBoxes Me("tb" & i) = "" Me("tb" & i).BackColor = vbWhite Next

Thanks for the reply. I have tried that, and it is still not working. Here is the code I wrote. --------------------------- Dim numberOfTextBoxes As Integer Dim textBoxName As String numberOfTextBoxes = 20 For i = 1 To numberOfTextBoxes textBoxName = "tb" & Me.i...

Hi, Essentially I want to edit a specific textbox depending on a number which is dependent on a number of things and varies each time the form is run. For example, if the number is 0 I want to edit tb0.value. If it's 1 I want to edit tb1.value etc. I have specifically labelled my text boxes in...

Hi All, I have created a system consisting of a data entry form etc. It was originally connected to one record source exported from a sharepoint site. I had to add a field to the sharepoint site and so i created this additional field and re-exported the data and changed the forms record...