Hello, I have a form with a field called "Document". I need to apply two different masks for this fiels. Is it possible? Thanks.
Hello, I have a form with a field called "Document". I need to apply two different masks for this fiels. Is it possible? Thanks.
You might try something like this....
If Me.chkOption = -1 Then
Me.txtField.InputMask = "000\-00\-0000;;_"
Else
Me.txtField.InputMask = "00000\-9999;;_"
End If
I did this, but when I apply the mask, all other 'documents' are masked with the same type from the last.
I need mask each item of the field.
I don't know what to say. If the data is not correct at the time of input then you will need to update the information. Perhaps an UPDATE query would help. Maybe you can add another column and store data of the other format/mask in the second column, switching back and forth between fields as needed.