Displaying Yes/no fields the same on all computers sometimes -1 or

's Computer Specifications

I have a Access database on a network. On some computers a list box that
displays the results of a query with a yes/no field in it is displayed as
either yes or no but on other computers the same field is displayed as -1 or
0. How do I get this to display either a yes or no on all computers?

's Computer Specifications

Access stores yes as -1, no as 0. One thing you could do is to have an IIF
statement in your query. IIF([yourfield]=-1, "yes","no") or put a textbox on
your form with the control source =IIF([your filed]=-1,"yes","no")

"bamahog" wrote:

> I have a Access database on a network. On some computers a list box that
> displays the results of a query with a yes/no field in it is displayed as
> either yes or no but on other computers the same field is displayed as -1 or
> 0. How do I get this to display either a yes or no on all computers?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MS Access Themes not displaying on some Computers	Nexent1	Microsoft Access Forms	1	16th Apr 2010 09:47 PM
RE: Displaying Yes/no fields the same on all computers sometimes -	ala_beach	Microsoft Access	0	17th Feb 2009 09:46 PM
Finding and Displaying Fields in a form w/3 fields	=?Utf-8?B?UGV0ZSBSb2Nr?=	Microsoft Access Getting Started	2	12th Dec 2006 04:22 PM
Not displaying right on diferent computers...	=?Utf-8?B?QXVzdGluIEtpcnNjaGVubWFubg==?=	Microsoft Frontpage	4	29th Jun 2004 04:46 AM
Active Directory Users and Computers name displaying	Brian	Microsoft Windows 2000 Active Directory	3	1st Nov 2003 10:19 AM