This code will prevent a beep when you hit [ENTER] or [TAB] ina text box whose maximum character limit has been reached:
Sub Form_KeyPress (keyascii As Integer)'Eliminate beep if {ENTER} or {TAB}If keyascii = 13 Or keyascii = 9 Then _ keyascii = 0End Sub