Full Version: Input Mask
UtterAccess Forums > Microsoft® Access > Access Forms
asimze
I need input field in format:
0fg4a 8ls9e lks98 j9s5d
there are two space between all groups of five combination small leter and number. In table need to be just string long 20 symbols, but at input field and report must to be this format.
Asim
AlanAnderson
Hi,

How about a mask something like:
0LL0L 0LL0L 0LL0L 0LL0L


Haven't tried it with 2 spaces but think it should work.

Regards

Alan
asimze
Thanks AlanAnderson.
But in group of five, any symbols can be number or letter!!!
Asim
cheekybuddha
It's not clear whether the order of numbers/letters must be exactly as in your example or whether they can be in any order.

This will allow any combination of letters/numbers:
<AAAAA\ AAAAA\ AAAAA\ AAAAA;;_

But I don't know how to get the 2 spaces in between each group.

hth,

d
AlanAnderson
Hi,

I'm stumped then.

I will see what I can find.

Regards

Alan
asimze
Hi,
there isn't order between numbers and letters. It can be all numbers or letters , any combination!!!
What if I would to put "-" ( symbol minus) between all group of five)?
TIA!
asim
cheekybuddha
Hi Asim,

Did you try my suggestion?

d
asimze
Hi cheekybudha, yes! Not good solution. must be something between group.
Regards.
Asim.
cheekybuddha
Do you want to save the spaces between the group, or only have the spaces displayed to the user?
AlanAnderson
Hi Asim,

Why not just save the numbers/letters all together in one long string then if you need to redisplay them at a later stage you can insert the spaces quite simply?

Regards

Alan
asimze
Hi cheekybudha,
only have the spaces displayed to the user.
TIA
Asim
asimze
Hi AlanAnderson!
This is security code, and input make lawyer!!! They are very rich and lazy!!!
It is not easy input very cryptic string long 20. Remember licence key on installing application.
TIA.
Asim
AlanAnderson
Hi Asim,

Then why not create four separate text boxes, each 5 char long and place them close together so that visually they seem to be part of the whole code but that the separation is clear enough.

Then concatenate them into a string something like this.

say vCode = txt1 & " " & txt2 & " " & txt3 & " " & txt4

Then for each text box you can set the input mask to password.

Regards

Alan
asimze
Hi AlanAnderson,
I will use this as final solution!
Thanks.
Asim
AlanAnderson
Hi Asim,

I hope your project goes well - hope I was able to help.

If you have any more issues don't hesitate to post again.

There are some wonderfully helpful people here on UA.

Good luck.

Regards

Alan
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.