Can't seem to format field in listbox on a form to display Yes/No?

[MLH]

SELECT DISTINCTROW qryVehicleList.VehicleJobID AS VID,
qryVehicleList.Vehicle, qryVehicleList.Reclaimed AS [Reclaimed?],
qryVehicleList.VehicActive AS [Active?], qryVehicleList.Sold AS
[Sold?], qryVehicleList.ProcFee AS [My Fee],
qryVehicleList.DMVFileNumber
FROM qryVehicleList
WHERE
(((qryVehicleList.TowCoID)=[Forms]![frmBrowseVehicles]![Combo0]));

Here's the expression in qryVehicleList's [Sold] field:
Sold: IIf(IsNull([VSaleID]),False,True)

I'm unable to get anything but minus one and zero to display in the
listbox.

[Mark]

Sold: IIf(IsNull([VSaleID]),"No","Yes")

"MLH" <CR**@NorthState.netwrote in message
news:uu********************************@4ax.com...

SELECT DISTINCTROW qryVehicleList.VehicleJobID AS VID,
qryVehicleList.Vehicle, qryVehicleList.Reclaimed AS [Reclaimed?],
qryVehicleList.VehicActive AS [Active?], qryVehicleList.Sold AS
[Sold?], qryVehicleList.ProcFee AS [My Fee],
qryVehicleList.DMVFileNumber
FROM qryVehicleList
WHERE
(((qryVehicleList.TowCoID)=[Forms]![frmBrowseVehicles]![Combo0]));

Here's the expression in qryVehicleList's [Sold] field:
Sold: IIf(IsNull([VSaleID]),False,True)

I'm unable to get anything but minus one and zero to display in the
listbox.

[MLH]

U dah man - perfect work-a-round.