Hi,
I have an ACCESS application which pulls data from an SQL Server table and displays it on a form for the user to update. One of the form fields is a text box which is populated by a varchar(16) column from the SQL table. I want to allow the user to add more than 16 characters into the field (the original column length) and have modified the SQL table column to the new length (275). Through the query analyzer, I have no problem updating and inserting strings of data longer than 16 characters into the altered column. However, in the application the form still only displays 16 characters from the selected record and still only allows the user to input 16 characters. Is there a property setting or something I'm missing in ACCESS that I need to set to account for the change in length of the text box?
thanks!
I have an ACCESS application which pulls data from an SQL Server table and displays it on a form for the user to update. One of the form fields is a text box which is populated by a varchar(16) column from the SQL table. I want to allow the user to add more than 16 characters into the field (the original column length) and have modified the SQL table column to the new length (275). Through the query analyzer, I have no problem updating and inserting strings of data longer than 16 characters into the altered column. However, in the application the form still only displays 16 characters from the selected record and still only allows the user to input 16 characters. Is there a property setting or something I'm missing in ACCESS that I need to set to account for the change in length of the text box?
thanks!
