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

  • Thread starter Thread starter bamahog
  • Start date Start date
B

bamahog

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?
 
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")
 
Back
Top