Change values of check box 1

[Wrathchild]

Is there any way to change the values of a check box from 0 or -1 to whatever the user wants?

thanks!

 

[K9Boxer]

No. Check Boxes are Boolean entities. Only the two values (0/-1) are possible: (also expressed as True/False -or- On/Off etc....)

 

[RegionsRob]

You can set the field to display Yes/No, True/False, On/Off. If you want to display other values, you can create a text box with an IIF statement: IIF(chkbx=-1,"True value","False Value&quot where chkbx is the name of the checkbox field and "True Value" and "False Value" are the labels you want to use.

If you want to STORE values other than -1 and 0, then you will have to use a text or numeric Data Type.

 

[braindead2]

one more addition to this. You can set up an option group using check boxes and then via code set the value

select case frame1
case 1
field.value = "this"
case 2
field.value = "that"
case 3
filed.value = "anythingelse"
end select