Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making textboxes 'blank when null'
Message
From
04/11/2002 07:03:08
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00718361
Message ID:
00718414
Views:
18
>>In order to make adding records easier I want to allow non_PK fields to be null. Naturally, when accessing them through SPT they show their null value in the forms.
>>
>>Is there a way to make them appear "blank when null" in the form, yet behave reasonably. By that I mean: if not changed they remain null; if changed they take the new value; if made blank they take appropriate value such as 0 for numeric. NVL() will not work in this case, I believe.
>>
>>TIA,
>
>How about using the NullDisplay property located in the Data Tab properties window?

Thank you, that was it.
Previous
Reply
Map
View

Click here to load this message in the networking platform