>Hi,
>
>Say I have a form with textboxes bound to a cursor (retrieved from a SQL Server via SPT) and some values in the cursor are NULL. I prefer that the customer does not see the NULL but instead an empty textbox. How do you hide the NULL from these textboxes?
>
>Also, I prefer not to change the value in the cursor from the NULL to empty string for 2 reasons: 1 time that this procedure will take 2 - on Save I would have to convert the value back to NULL.
>
>TIA.

Check:
SET NULLDISPLAY TO command
and
Object.NullDisplay property in HELP.

BTW If the NULL values are NOT needed at all I prefer to set default value to empty field (depends of its type). Only type that allow NULLs is datetime :-)
Of course this is dependong the application, sometimes NULLs are mandatory.