468,737 Members | 2,597 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,737 developers. It's quick & easy.

create new textbox at runtime

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
1 8215
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.

Similar topics

4 posts views Thread by Tom Rathbun | last post: by
2 posts views Thread by Patrick Marti | last post: by
3 posts views Thread by Don Lee | last post: by
3 posts views Thread by Ricardo Corsi P. Cesar | last post: by
3 posts views Thread by RSB | last post: by
1 post views Thread by Bruno Pimentel Machado | last post: by
1 post views Thread by CARIGAR | last post: by
xarzu
2 posts views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.