set nulldisplay to "" will help
datetime values can be converted using format or inputmask proprieties, or by changing the field to type "D" using dbsetprop or one of the similar commands.
You could also make the value of the textbox be something like eval(dtoc(mydatefield))
>Is there a way to display SQL Server NULL values as blanks without resetting the value of all NULL fields? When I add a new record, I'm trying to avoid setting all the fields to "" values. Any ideas?
>
>Thanks,
>Doug
--Todd Sherman
-Wake Up! Smell the Coffee!