Output as yes/no NOT true/false

[DMT Dave]

Hi Guy's is there a way i can change how a recordset will out put from the "paid" field ? the output results in true/false, can this be changed to Yes/No, the field is set to Yes/No also the format is set to Yes/No

Set rs = CurrentDb.OpenRecordset("Select tblInvoices.InvoiceDate, tblInvoices.InvoiceNumber, tblInvoices.Customer, " _ 
& "tblInvoices.Qty, tblInvoices.Ref, tblInvoices.Description, tblInvoices.Total, tblInvoices.Paid, tblInvoices.PaidDate " _
                                & "FROM tblInvoices " _
                                & "WHERE InvoiceDate Between #" & StartDate & "# And #" & EndDate & "#")

[June7]

Output to where? If not exporting data, why does this matter?

Can convert the value to a string. One way: Format([Paid], "Yes/No") AS PaidInv

[isladogs]

You can do this in the table design.
Select the field then on the General tab, make sure you format as Yes/No and ensure the display control is set to textbox on the Lookup tab.

Having said that, its often easier to visualise if you set the display control to checkbox
However they are displayed, the values are still stored as 0 & -1

[June7]

Colin, OP said table field is set for Yes/No.

I tested this and in spite of table setting, recordset field outputs True/False, not Yes/No. A query object will carry forward Yes/No but recordset does not.