NULL Values In Combo Box

[Creeder]

Hi,

Basically I have a SQL pass through statement that retrive data from a table into a cursor. The cursor is then used as a rowsource for the combo box.

Example of data in cursor

Column 1 Column 2 Column 3
.NULL. 2134 21324
.NULL. 4344 34343
FoxPro 3233 23233
VB 43443 34344

I've assigned the rowsource to the 3 columns.
My question: Is there anyway NOT to display the NULL values but still display the column2 and column 3 when the user select from the combo box?

I've tried NullDisplay property but nothing seems to work. Or do i need to manually scan through the table and replace each .Null. value with a blank?

Thanks in advace.

Yue Jeen
[sig][/sig]

 

[TomasDill]

Try SET NULLDISPLAY command. [sig]<p>Vlad Grynchyshyn<br><a href=mailto:vgryn@softserve.lviv.ua>vgryn@softserve.lviv.ua</a><br>[/sig]

 

[Creeder]

Thanks Vlad, It works

Yue Jeen [sig][/sig]