How can I force qry field to display Yes/No or True/False?

[MLH]

Here's my field in qry907908CheckS umData:

Active:
IsVehicActive([tblVehicleJobs].[VehicleJobID],"qry907908Chec kSumData")

Clicking on the field in the QBE grid, FORMAT property setting for
this field are NUMERIC only. I want to choose Yes/No - but that ain't
a choice.

(1) Why not?
(2) What can I do to MAKE it a choice?

Function IsVehicActive(W hichCar As Long, CallingProcedur e As String)
As Boolean
.... blah, blah, blah ...

End Function

[Rick Brandt]

Re: How can I force qry field to display Yes/No or True/False?

MLH wrote:

Here's my field in qry907908CheckS umData:
>
Active:
IsVehicActive([tblVehicleJobs].[VehicleJobID],"qry907908Chec kSumData")
>
Clicking on the field in the QBE grid, FORMAT property setting for
this field are NUMERIC only. I want to choose Yes/No - but that ain't
a choice.
>
(1) Why not?
(2) What can I do to MAKE it a choice?
>
Function IsVehicActive(W hichCar As Long, CallingProcedur e As String)
As Boolean
... blah, blah, blah ...
>
End Function

You are not limited to the choices in the list. Use the keyboard.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com