create new textbox at runtime

[pepsi330ml]

I need to create a crosstab report that does not need the user to know
the total number to columns and manually add a new textbox and amend
the VBA code. The VBA code should handle everything from getting the
total number of col and create the exact number of textbox. Tat's is,
the user only need to ran this report and tat's it.

http://support.microsoft.com/default...b;en-us;328320
This information from msdn is only dynamic when the user update the
report textbox and VBA coding.

So far, i managed to get the total number of col but unsuccessful in
creating the new textbox. Can this be done at all?

If it's possible, can someone teach me how.
Thank in advance.

[Tom Warren]

Check out CreateControl() in help. It's mainly used for wizards and
such, but I found some uses for dynamic forms and reports.

HTH
Tom
On 9 Mar 2005 00:02:25 -0800, pe********@hotmail.com wrote:

I need to create a crosstab report that does not need the user to know
the total number to columns and manually add a new textbox and amend
the VBA code. The VBA code should handle everything from getting the
total number of col and create the exact number of textbox. Tat's is,
the user only need to ran this report and tat's it.

http://support.microsoft.com/default...b;en-us;328320
This information from msdn is only dynamic when the user update the
report textbox and VBA coding.

So far, i managed to get the total number of col but unsuccessful in
creating the new textbox. Can this be done at all?

If it's possible, can someone teach me how.
Thank in advance.