Checking a text box to see is a character has occured 1

[ftpdoo]

Hi,

I want to check a text box to see is a character has occured. If the "-" dash character appears anywhere in the text box then a msg box would be displayed.

Any idea's???
Thankx,
Jonathan

 

[nickjar2]

Ho Jonathan,

In Access there is an event called keyPress

Private Sub jj_KeyPress(KeyAscii As Integer)
dim s as string
sr = Chr(KeyAscii)

KeyAscii = Asc(UCase(s))
If KeyAscii = 45 Then
MsgBox "Your Message"
End If

end sub

Nick

 

[mac318]

If Instr(1, [TextboxName, &quot;-&quot <> 0 then
MsgBox(message)
End If

mac318