New Page or View for Text Box

  • Thread starter Thread starter SmokyMtnzz
  • Start date Start date
S

SmokyMtnzz

Hi,

I have a simple form that I wish to have each Text Box show up or
appear as a different page when someone is keying the info.
Basically, I only want one Text Box show up on their screen at a time,
enter a number, press enter or tab, and their at the next Text Box,
and on and on.

I read about using the Tab Control, but that would be unpractical
because of the 75 - 100+ Text Boxes to be keyed into. I tried the
Page Break but that didn't work.

I hope that this is a very simple solution and I am overlooking some
kind of setting in my form.

Thanks for any help you all can provide.

Sincerely,
SmokyMtnz
 
hi,
there is a simple solution. I've used it before.
just set the visible property to true or false
but with that many text boxes, it might take a tad bit of
keying.
me.textbox1.visible = true '(to make it visible)
me.textbox1.visible = false '(to make it disappear)
set the visible property for all the boxes at form load
there is no tab event so you would have to use the enter
event.
i'm not sure how you are handling the data after input so
i really don't know how to tell you to make it move from
one box to another. I am thinking of a 100 plus select
case.(shiver)
but like i said, with that many text boxes, you may have a
problems setting the conditions and it could get tricky.
you might want to read up on the visible property in help
also read up on enable. this property grays out the box
and doesn't allow input while grayed out.
i do foresee one possible problem with your technique. it
would require flawless input.
good luck
 
Thank you for the information. I'll give your idea a try, but I think
I'm going to have to restructure my form to make it more manageable.
I will probably split them up into groups and put them into a Tab
Control. A question I have is to when I get to the last Text Box on
page one of my Tab Control, how do I make it go to the first Text Box
on page two, etc. I looked at the Tab Order and it would show the
Text Boxes on only one page, not everything in the Tab Control

Thanks again.
 
Back
Top