Set text box length and move to next text box

[Joe M.]

Hi. I would like to set the max length on a text box and when it's reached
the focus will move to the next text box. I've looked for a max length
property and such but no success. Can someone help?

Thanks,
Joe m.

 

[stockwell43]

Hi Joe,

Is there a reason why you want it to jump to another textbox? In any case, I
believe the Max for a text field is 255 characters. However, based on what
you describing where there is a possibility of maxing that out, just make one
field and insteat of a textbox make it a memo field. Just a thought.

As far as your original question, I am not sure how to make it jump from one
textbox to the other if full. I am sure someone on this board will know
though.

Take care!

 

[John Spencer MVP]

If you mean to want to set the length of an entry to 10 characters and when
the tenth character is entered the entry cursor will automatically move to the
next text box in tab order, take a look at the AutoTab property. For this to
work you need to set up an input mask that specifies the length you want.

For instance, for a 10 character entry you might have an input mask of
CCCCCCCCCC (any character accepted, must enter 10 characters)
Or
&&&&&&&&&& (any character accepted, optional length)

The second will not autotab unless you enter 10 characters
The first will not let you leave the field until you enter 10 characters (or
no characters)

Take a look at the help on Input Mask and AutoTab for a more complete explanation.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[John Spencer MVP]

Yep. I sure got that backwards. AND I was looking at the help when I wrote that.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County