468,140 Members | 1,449 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Create new textbook at runtime

Hi All,

i want to create a dynamic crosstab report. The method shown in
http://support.microsoft.com/default...b;en-us;328320
is not a dynamic report as it require the user to manual add new
textbox if there's a new employee.

What i actually want is the report do not require the user to change
anything before running the report. The report will check the total
num of col and create the exact number of textbox on the report.I can
find out the total number of col but i'm unsuccessful in creating the
textbox.

Is what i want possible? If yes can somebody teach me how?

Thanks in advance.
Nov 13 '05 #1
3 1860
In Access, it is not practical to add text boxes at run-time, but you can
create a pool of invisible text boxes, and make them visible, position them,
and bind them to fields at run-time.

On 8 Mar 2005 23:49:18 -0800, do******@singnet.com.sg (Don Lee) wrote:
Hi All,

i want to create a dynamic crosstab report. The method shown in
http://support.microsoft.com/default...b;en-us;328320
is not a dynamic report as it require the user to manual add new
textbox if there's a new employee.

What i actually want is the report do not require the user to change
anything before running the report. The report will check the total
num of col and create the exact number of textbox on the report.I can
find out the total number of col but i'm unsuccessful in creating the
textbox.

Is what i want possible? If yes can somebody teach me how?

Thanks in advance.


Nov 13 '05 #2
i don't need to consider whether it's practical or not. The design of
my project will hav infinity number of a certain fields. Therefore, i
cant forecast how many textbox there are.

Now that u mentioned it's not practical, so can it be done??
If yes, y not u teach me how....
thanks

Nov 13 '05 #3
On 9 Mar 2005 00:18:27 -0800, pe********@hotmail.com wrote:
i don't need to consider whether it's practical or not. The design of
my project will hav infinity number of a certain fields. Therefore, i
cant forecast how many textbox there are.
It doesn't matter if you can forecast how many there are because the maxium
number of controls you can have on the form is fixed (511 I believe), and the
maximum number or columns allowed in your crosstab is also limited to 255.
Therefore, create as many hidden text boxes and labels as you can given the
Access limitations, and that's the pool of controls you have to work with.

Now that u mentioned it's not practical, so can it be done??
If yes, y not u teach me how....


Yes, but it's harder than creating the pool of hidden controls, and it doesn't
buy you anything since the Access limits are the same either way.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Larry | last post: by
7 posts views Thread by MarkoH | last post: by
6 posts views Thread by shapper | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.