Mike,

Thanks.

The TTOD() function you suggested, works well if Text.ControlSource is not bound to Table.Field. But I already said it is bound to datetime field.

Manoj

>>>>>>>>>>>>>>>>>>>>
>All,
>
>I am having a problem in TextBox. The control source of the textbox is DateTime field. I want to suppress time portion from TextBox. I tried with Text.DateFormat = 13 and Text.Format = ‘YS’ but the problem is still there.
>
>
>01/01/2001 01:03:02 PM
>
>I want
>
>
>01/01/2001
>
>Many thanks in advance
>>>>>>>>>>>>>>>>>>>>>>
>
>Take a look in the help file at the TTOD() function