Using vbKeyReturn in KeyPress Event of a TextBox [RESOLVED]

[mudfish]

Here some Code I use to make sure it "N/Y"

Private Sub txtTempPostNY_KeyPress(KeyAscii As Integer)

If KeyAscii = 121 Then
    KeyAscii = 89
ElseIf KeyAscii = 110 Then
    KeyAscii = 78
ElseIf KeyAscii = 89 Or KeyAscii = 78 Or KeyAscii = 8 Then
    KeyAscii = KeyAscii
Else
    Beep
    KeyAscii = 0
End If

End Sub