Switching check box's

[dubay013]

I posted a thread earlier this week about check box's in access. Basically, we have the checkbox's representing a negative when checked when they really mean a positive (yes). My coworker would like to fix the problem entirely by switching all the checkboxes. So, all the boxes that are currently checked need to be unchecked and visa versa.



Does anyone know how to do this?
Thanks much!
Jenny

[ranman256]

make the check boxes indicate Negative by check for < 0 in field value in the property:
checkbox .controlsource = [field]<0
then it will show TRUE if negative.

or
if they boxes are connected to a field,: true (yes, -1) is checked.
0 ,false,no = unchecked.
run a query update this field.

[dubay013]

Thanks for responding ranman256 but not sure I know what you mean.

The boxes are connected to a field. By checking the box you are indicating if a survey station was sampled or not. Right now we have it set up that if you check the box you did not survey the point, so it is backwards kind of. We would like to flip all the existing boxes to their opposite. So right now in our database a checked box = not sampled = -1 and visa versa. We would like to make the statement agreeable by switching all the past checked boxes to checked box = sampled = -1

Does that make more sense?

Thanks,
Jenny

[ArviLaanemets]

Run a query

UPDATE YourTable
SET YourSampledField = Not YourSampledField

[dubay013]

I think I can create a new field then just put in a default value expression to switch the checked boxes and delete the old field. I just don't know what the code would be for the expression builder :/

[Micron]

I agree with the answer given, but since you're at the novice level, you should do this on a copy of your table first, just in case you make a mistake.