By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,313 Members | 1,240 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,313 IT Pros & Developers. It's quick & easy.

create new textbox at runtime

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.