I have an access front-end I am running against a SQL- Server 2000 back-end database. The problem I am having is with two fields which I called user_id and Job_user_id which were defined as nvarchar (7). I now have user id's that are of length 8. I thought just going to the table defintions and increasing the length to 10 on the SQL Server will take care of it but I am still having id's that are 8 characters in length being trancated to 7 in the VBA client causing some of my joins to fail. For instance

Private Sub lstUnassigned_DblClick(Cancel As Integer)
MsgBox Me.cmbJOB_USER_ID
Me.cmbJOB_USER_ID = Me.lstUnassigned
End Sub

The MsgBox shows the Me.lstUnassigned trucated to 7 characters instead of 8 that is in the SQL Server database and so the Select statement in the object to fail.

I have also checked all my stored procedures and made sure that any user_id references have been increased to 10. I just cannot make the client stop truncating the JOB_USER_ID/user_id fields. Any ideas? Thanks, SKN.