Input Mask that Starts at end of Text Box

[gracm25]

I have an input mask for an IP address in one of my tables. All input masks begin with the same first 5 digits "XXX.XX." When a user tabs to this field, I would like the cursor to start at the end of that pre-populated text string so that they can type in the remaining six digits. How can I do that?

 

[JohnLee]

Hi,

If for instance your first 5 numerical characters were always 45672 then in the Input Mask field in your table for that particular field you can enter either of the following:

"45672"9999999

With the "45672" enclosed in double quotes, when ever a new record is created these five characters will always appear in the field, the 9999999 characters are place holders and can be either a numerical character or a space.

If you don't like the 9 place holder you can use the # place holder which does the same job.

Again whenever you create a new record these five characters will appear first, you just simply enter the required characters where the place holders are.

Hope this is of assistance.

John

 

[gracm25]

John,

Thanks for the input. However, how do you get the cursor to move to the end of the text string in that field. If I always want the first 5 digits to be 45672, how do I get the cursor to always be at the end of that field. Thanks.

 

[JohnLee]

Hi,

As soon as you start to type the information, it will automatically start at the 6th position, so you don't have to worry about that. This is because the first five characters are set by the mask, it knows that any data to be entered must start at the 6th position.

John