Setting a constant in the text field

[fcbuek]

Hi,


I have a question for my input mask in the text field I have set to:

AAAA"/"AAAAAAAA"/"A

Input mask:

"    /        / "

I have a question, is there any way I can use VBA or somehow change the input mask to set permanently three 0 to 5 positions
[/CODE]
Input mask I would like to get:

"    /000     / "

because I noticed when entering data into this field that they always repeat themselves. I tried to use, but the zeros in the field are not recorded in the table

AAAA"/000"AAAAA"/"A

Thank you in advance for your help

[CJ_London]

the / won't be included either

suspect it wont work but you could try

AAA\/\0\0\0AAAAA\/A

but usually better to split your value into it's component parts and store separately - they can be concatenated for display purposes as required.

Reason I suspect it won't work is that input masks are about limiting user input, not creating characters to automatically include in your value - for that you would use vba in the control after update event.

something like

mycontrol=left(mycontrol,3) & "/000" & mid(mycontrol,4,4) & "/" & right(mycontrol,1)

another way may be to use the control change event so that when the user has entered the 3rd character vba automatically adds "/000"

[fcbuek]

I tried to apply and it also doesn't work

Private Sub Number2_AfterUpdate()
mycontrol = Left(mycontrol, 3) & "/000" & Mid(mycontrol, 4, 4) & "/" & Right(mycontrol, 1)
End Sub

[CJ_London]

it wont since you are referencing 'mycontrol' not the name of your control