Hi!
Try to set the NullDisplay property or use SET NULLDISPLAY command.
You can also get data into the ADO recrdeset by the way that it does not return null values. For SQL Server it is IsNull() function, for VFP it is NVL. For example:
SELECT MyField1, IsNull(MyField2,"") as MyField2, ...
This wa empty string will be returned instead of NULL value.
>Hi,
>
>I get a ComboBox class for bound a ado recordset (using RecordSource=thisform.adoData.oFields['MyField'].Value)
>
>This work fine except if the field MyField have NULL.
>
>The combos get a Display field and a Value field, the source is a array (also tested using value). The value field is integer.
>
>If i simply write the value not problem . Only when i selected it using the list displayed for the combo not work (is selected ant then simply is cleared the value, but DisplayValue get (something) the rigth value).
>
>I try several things from 2 or 3 weeks.... Asign a default value, '', 0, etc...
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.