Forum Discussion
access - using input mask
hey, really need some help in regard to input masks. I'm doing a stock database and in one of the fields, some rows have , / and numbers. Not every row has them and every time I try to add a comma ...
you can remove the Input mask and just add code to the Textbox's
Keypress Event:
'arnelgp
'will accept Any character and convert to uppercase
'____________________
'
Private Sub firstName_KeyPress(KeyAscii As Integer)
Dim i As Integer
i = Asc(UCase(Chr(KeyAscii)))
If KeyAscii = 8 Or KeyAscii >= 32 And KeyAscii <= 126 Then
KeyAscii = i
Else
KeyAscii = 0
End If
End Sub