>how to set them empty like vfp table ?
>
>how to use date format instead of datetime on forms ?
SQL Server does not have empty dates. The dates can be set to NULL in SQL Server. In your form you can display NULL dates as empty and do back conversion from empty to NULL when saving.
If it's not broken, fix it until it is.
My Blog