Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

YesNo fields are 0 and -1

Status
Not open for further replies.

meldrape

Programmer
May 12, 2001
516
0
16
US
Greetings,

I have a database table that I recently imported into Access and will eventually be upsized to SQL. The yes/no fields are of course -1 and 0. I do not wish them to show up like this in a report. How do I change them to Yes and No for the report only... Thanks in advance!
 
Change the format on the property sheet to Yes/No
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top