>>>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.
If it's not broken, fix it until it is.
My Blog