Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Hiding '.NULL.' in grids
Message
 
To
22/05/1997 00:20:45
Larry Long
ProgRes (Programming Resources)
Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00033213
Message ID:
00033227
Views:
40
>>I'm using updatable views. When I display the results of a left outer join, some of the fields contain .NULL.. This does not create any problems with correct operation of my program. Often I am using a combobox control to edit a character field that may contain .NULL.. Again, no problem, the combobox works fine and the '.NULL.' goes away when the combobox gains focus. My problem is that the display of '.NULL.' in my grid does not look good. There is a property on textboxes called NullDisplay that allows me to substitute other text to be displayed in place of NULL, however when I use SPARSE = .T. the grid displays the data and gives me no NullDisplay property. What is the easiest way to get the Nulls out of my grid display????
>Try
>SET NULLDISPLAY TO " "
>in your startup code

Thank you -- works perfectly! I guess it is time for me to read my VFP reference manual again. :)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform