RE: [MS_AccessPros] creating controls in code

I would have a lot of hidden text boxes and make them visible as needed. I think there may be a better method but we don't know much about your requirements.

To: MS_Access_Professionals@yahoogroups.com
From: wgriffin48@mchsi.com
Date: Sat, 25 Feb 2012 01:01:33 +0000
Subject: [MS_AccessPros] creating controls in code

Hello Group;

I am trying to format a report that has an unknown number of textboxes to head an similarly unknown number of columns. So I am trying to use the "NEW" keyword to create textboxes on the fly.

Dim txtNB1() As TextBox

With rst1

If strNB1 <> !Symbol Then

If !strTrainDirection = "Northbound" And !strTrainClass = "1st" Then

strNB1 = !Symbol

NB1 = NB1 + 1

Set txtNB1(NB1) = New txtNB1

Me.txtNB1(NB1).Text = !Symbol

End If

End If

etc........

How do I get this to work? and assign values to the new textbox properties?

Walter Griffin

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/