instancing textboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there.

I have noticed that you can instance forms and I was wondering if you could
do this with a series of text boxes on a form, i ask this as I currently have
a form which updates (currently 6) unbound textboxes from a date range query
and often I have found that all the records are not being shown, so does
anyone know a way of creating/replecating more textboxes on the form
according to how many records show up?

Thanks in advance, Simeon
 
I have noticed that you can instance forms and
I was wondering if you could do this with a series
of text boxes on a form, i ask this as I currently
have a form which updates (currently 6) unbound
textboxes from a date range query and often I have
found that all the records are not being shown, so
does anyone know a way of creating/replecating
more textboxes on the form according to how
many records show up?
Click to expand...

Access does not have a "control array" as did the classic VB software
(through V6). The most common way people handle this is to create the text
boxes with their Visible property set to No, then set the Visible property
to Yes/True on just as many as you need. Access does not lend itself well to
creating Controls at runtime.

I get uncomfortable when people talk about "unbound" Controls because so
often that was their last-ditch effort to solve some unstated problem which
would better have been handled in another way. I especially get uneasy when
people talk about showing multiple Records in the Detail Section of a Form.

It seems possible that some Table restructuring and a continuous form view
Form embedded in a Subform Control might address your needs with less code,
and more reliance on the way Access is intended to work.

Larry Linson
Microsoft Access MVP


Larry Linson
Microsoft Access MVP
 
thanks larry

Im not sure If i can do one of my forms that way but ill see.

thanks, Simeon.
 
Back
Top