Change values of check box

  • Thread starter Thread starter docmom123
  • Start date Start date
D

docmom123

I have ACCESS 2007 on the front end and SQL Express 2008 on the back end. I
have several check boxes on my Access forms, but I want the values to be 1
and 0, not -1. Is this possible??? Is there an on click or after code I
could use?
 
Will that "fight" with the SQL? I'll try it! Thanks!!

golfinray said:
Something like IIF([yourfield]=-1, "1","0")
--
Milton Purdy
ACCESS
State of Arkansas


docmom123 said:
I have ACCESS 2007 on the front end and SQL Express 2008 on the back end. I
have several check boxes on my Access forms, but I want the values to be 1
and 0, not -1. Is this possible??? Is there an on click or after code I
could use?
Click to expand...
Click to expand...
 
Back
Top