>>>>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 Nulldisplay to ""
>>
>>Do I understand correctly that setting NullDisplay to "" would show the [""] in the text box? This is what I see but wanted to be sure that I am not missing something (as I was hoping to completely make the textbox empty).
>>
>>UPDATE: Set NullDisplay to "" works. I was setting the NullDisplay of the textbox and it didn't quite work. So I should be all set. Thank you.
>
>What and where exactly did you do? I added SET NULLDISPLAY TO '' in Form's DE and it seems to have no effect. I still see null in my controls.
I have it in my LOAD method and it works very well.
"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