Hi,
I need to do an input mask in a form that has "PI 09/" fixed, and 2 numbers after that increment with each record created. Ie: I will have something like this:
PI 09/001
PI 09/002
PI 09/003
Any help please?
Thanks
Hi,
I need to do an input mask in a form that has "PI 09/" fixed, and 2 numbers after that increment with each record created. Ie: I will have something like this:
PI 09/001
PI 09/002
PI 09/003
Any help please?
Thanks
Doobybug
Use this input mask (>"PI 09/"0009;;_)
> Makes all letters capitalized
"PI 09/" - forces PI 09/ as the constant characters - These will display all the times when you tab into the field.
the final part 0009 forces you to enter 3 characters (001, 002, excetera), the 9 allows a 4th character to be entered once you get into the numbers 1001, 1002) This allows you to go as high as 99,999. If you need to go higher just add an additional 9 onto the end of your input mask
The final part ( ;;_ allows access to use a underscore to show where to add your data when you tab into the field you will see PI 09/____, [4 dashes to hold your place in the mask]).
The final input mask will look like this -- >"PI 09/"0009;;_
Let me know how that works for you.
baksg1995
I was reading my post over and realized that with 0009 your range of numbers are 9,999 not 99,999. Of course if you get to 10,000 just change it to:
>"PI 09/"00009;;_
As you can see just keep adding as you get higher and higher.
Oh and in my original post I typed (>"PI 09/"00009;;_) - do not use the parentheses - leave those off the input mask.
Celtic57
PS - baksg1995 is my office login to this forum