>I'am using a ADO to access the database and when I use the statement/command to insert a record like this;
>
>oRS = oCon.Execute("Insert Into Sample (Name, BDate, TranDate) Values ('Name', '01/20/1975', '')")
>
>then when I view that record the TranDate has a value of 01/01/1900 how can I control that I want the TranDate to be empty not 01/01/1900.
>
>Thank For Your All Input.

Maltin,
In your database set trandate to accept nulls and do not pass anything or null when it's empty. ie:

oCon.Execute("Insert Into Sample (Name, BDate) Values ('Name', '01/20/1975')")

Cetin