I would like to create a text box, without having one appear on my form. Is this possible? Or if I do that does the textbox already have to be on my form. How?

I know I can declare an varaible as a text box, Dim txtTest as Textbox, but if I try to assign a value to the text box I get an error. i.e.:

Dim txtTest as Textbox

txtTest.Text = "Test"

Thank you,
Jennifer

Hi

You could add the textbox somewhere on your form and then use *Text1.Visible = False* in your form load sub. This way it wont appear when the program is running but you could still assign text to it.

Regards
Marnus

Maybe you can use the Visible property of the textbox?

Either in the properties window or as code: txtTest.visible=False

I'm a little curious, though. Why do you want a textbox if it shouldn't be seen? Can't you use a variable instead to hold your values?

I am trying to dynamically create text boxes. The amount of text boxes will be based on how many records are in a database table. I am not going to know how many text boxes to create until I query the database.

My main goal is to dynamically create an array of text boxes.

Any ideas?

Thank you,
J

Well, ive tried this approach, but not sure it's the right way to do it:

I copied/pasted a textbox on a form to make it a controlarray (dont know how else to do this), then deleted the new textbox. The remaining textboxname is now Text1(0).

I added a commandbutton with this code:

Dim x As Long
Dim y As Long
y = 100

For x = 1 To 3
    Load Text1(x)
    Text1(x).Top = y * x * 10
    Text1(x).Left = 10
    Text1(x).Width = 1500
    Text1(x).Height = 100
    Text1(x).Visible = True
Next x

You can address the new textboxes with their x value, e.g. Text1(2).Text. But I imagine it could be difficult to keep track of textboxnames and the values they should hold, but it can be done.

Hope this may give you an idea to solve your task!

... or simply you could put a textbox in your form and set its index property to 0.

I'm just curious why you have to populate your form with n number of textboxes. what if you got thousands of rows? don't you want to use a grid?

Jennifer,

Take a look at this article.
I used its theory to create a quite complex venn diagram by dynamically adding controls.
It now works well after a lot of trial and error

http://www.thescarms.com/vbasic/DynamCtls.asp





======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================