By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,654 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Jul 24 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Jul 24 '07 #2

P: n/a
MLH
U dah man - perfect work-a-round.
Jul 24 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.