For background information I am using ADO and ASP with SQL Server 7.0 and Visual Interdev. The project is for a corporate Intranet and uses IE 5 for a browser. I am using maxlength to limit the length of user entries in an INPUT textbox. If I do not define the maximum length of user entries and the user enters too many characters I receive an error message when trying to Submit the Form.

Regardless of how it is done by hardcoding or using oRS.Fields(Customer).DefineSize, maxlength works fine. However, when I set the value of the textbox to the coresponding ADO field oRS(Customer), and attempt to drop the mouse cursor into the textbox it does not work more than 2% of the time.

I have about 50 textboxes on this form and there are about 40 more forms to go for this project. If I Tab into the textbox, it becomes highlighted and I can enter data up to the defined limit. All is well. Additionally, I can drop the mouse cursor at say position 5 of the textbox and backspace to position 1. This will allow me to enter up to 5 characters even though the field is formatted for a greater number.

By setting datafld to oRS.Customer and removing all reference to value, I can update the data to the table but am unable to see it in the textbox.

Any suggestions? I am going for a cup of coffee and hope there is a solution. Perhaps version 8 of Visual Studio with Service Pack 5 and IE 8 will solve this problem. However, I have to deliver this gem before those products become a reality. By the way I suggested West Wind Connection but that is not a possibility as it is not a corporate standard.

Tom