access - using input mask

Copper Contributor

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 or a number it will not let me and when I add it into the input field it goes in the exact spot on every row.
The instructions I was given for the particular field was 'Any characters or spaces can
be added, all in capitals'. I've looked everywhere for help and nothing helped. please help 

1 Reply


you can remove the Input mask and just add code to the Textbox's 

Keypress Event:

'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
        KeyAscii = 0
    End If
End Sub