Changing Yes/No CheckBox Value (1 Viewer)

[JamesMcS]

So what you need isn't a check box at all. If you want to actually use the word 'unemployed' or 'desempregado' to search by, then you will have to have a text field in the contact table that stores that word for each record.

But, again, why would you want to do this? Why not just use the check box method, which will say for each contact "yes I am unemployed" (check box value is true) or "no I am not unemployed" (check box value is false)?

 

[tgei346]

Yes, I know that, but I think it's not the best way to do this...
Can be done, but it's not the best way

I try that before, but I just can't search the unemployed people using that method.

 

[JamesMcS]

Well, I'm not sure how I can help further on this. The database I attached last week searches for contacts where the desempregado yes/no field is either true or false.... sorry I can't help further.

 

[tgei346]

Don't worry
I really really appreciate your time I think I can do this by my own now.
If I need your help again I start a new post

 

[JamesMcS]

Good luck!

 

[ems2000]

You can also change the value to text.
if me.checkbox=0 then
me.ctrl ="House"
end if
if me.checkbox=-1 then
me.crtl = Garage
endif

 

[gemma-the-husky]

MsfStl

i haven't read the whole thread, but I am pretty sure you really do not want to try and coerce access to use "artificial" values for true and false

what difference can it make whether a "true" value is stored as plus 1 , or minus 1? That is just a detail that can be easily managed.

On the other hand to try and use a logical "false" value (ie 1) as a "real-world" "true" value is almost bound to lead to confusion somewhere down the line.

 

[vbaInet]

Looks like that MsfStl chap isn't around anymore.

On the other hand to try and use a logical "false" value (ie 1) as a "real-world" "true" value is almost bound to lead to confusion somewhere down the line.

Yep! And 0 is False and any other number is True.


I thought it was the other way round. -1 is true, and everything else is false!