>Hi Larry
>
>whenever i use this nothing is happening, no change to the field occurs and all the 50 spaces are goin to the SQL Server
>
>Thanks
>Anwar

Open your form that has this CA in the Class Browser. Click the button that says View Class Code as the tooltip. Copy-and-paste the code here so we can see where the problem may be. You can delete code from your post here that is not relevant to your problem. Thanks.