>>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.
>
>Set the NullDisplay property of the text boxes to show whatever you want for NULL.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham