>My textbox has a maxlength and I want the cursor cannot go on the next control when the maxlength is reached. What is the best way to keep the cursor in the textbox? Thank you in advance.

It will not go as long as you use
SET CONFIRM ON