Thank you Dan,

This is a very good way, it's working fine.

BR


>>I am trying to display the date from SQL server database into a window form textbox as "dd/MM/yyyy", but it shows the time also.
>>even this does not work :
>>textbox1.text = format(dteDateandTime, "dd/MM/yyyy")
>>
>>beacuse I am using Databinding:
>>Me.txtRegDate.DataBindings.Add("Text", myDS.Tables("Member"), "RegDate")
>>
>>Any idea how to avoide this.
>>
>>Thanks for the help
>
>Ahmad,
>
>You might want to look at the Format and Parse events. Binding.Format
>
>Dan