creating text box dynamically in ms access

  • Thread starter Thread starter ravindar thati
  • Start date Start date
R

ravindar thati

can any body please tell me the code to create text boxes dynamically
or else please give me the link abt that information


Thanq
 
See help on CreateControl

In general, this is only useful if you are creating some kind of wizard form
that creates whole forms for end users. You don't want to be creating text
boxes on the fly for a normal form.
 
See help on CreateControl

In general, this is only useful if you are creating some kind of wizard form
that creates whole forms for end users. You don't want to be creating text
boxes on the fly for a normal form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.






- Show quoted text -
Click to expand...

It is my understanding that the CreateControl( ) function only works
in design view. If the intention is to populate a form with indexed
controls at run-time, then the controls must be created ahead of time
and named with the index in the name. They can be invisible until
they are needed. For example, if you created a series of labels named
LABEL1, LABEL2, LABEL3,etc., then they can be called later as if they
were "created", using the following syntax:
iLabelTally=1
me("Label" & format(iLabelTally).Top = iLabelTop
me("Label" & format(iLabelTally).Left = iLabelLeft
me("Label" & format(iLabelTally).Width = iLabelWidth
me("Label" & format(iLabelTally).visible = True

In versions of Access prior to Access 2007, the effective limit is
around 200 controls. The screen will hold 500+, but will slow down
appreciably. Access 2007 cannot handle (as of this writing) anywhere
near that number, as it takes 1 second to display and configure each
control. Thus 200 controls will take about 200 seconds to display on
my Pentium 4.
 
Back
Top