Option Button Creating -1 in Table instead of +1

[lukasgill]

Hi there,

I have a problem where the option buttons within a form are creating a "-1" in the Table instead of a "+1"

The reason this is a problem is because i am using a COUNT query which obviously gives me a negative total, such as "-23" instead of "+23"

I would really like the option buttons to store a positive value instead of negative. How is this possible?

Many Thanks, hope somebody can help

 

[CEH]

Are you sure you are using an option group? Sounds like a checkbox to me.... True /false..... "-1" or "0"...Yes/No. With an option group you can set your values... Look at default value in your properties on each one.

 

[lukasgill]

I am not using an option group, i am using 2 single option buttons.

I have just tested the option group and i can indeed set the default value to "1", however you can only give the value "1" to a single option in the group. I still want to have the Value "1" given to each option which is selected

What you said about the checkbox yes/no being -1 or 0 is ideally what i want...but have 1 or 0

Is this the wrong way to go around this?
Would it be easier to have a function somewhere which converts the total COUNT (which is a negative total) into a positive one?

 

[CEH]

Looks like a single option button is the same as a checkbox.. value True/False.... "-1/0"..... I'm not really sure if you can change the values on a "True/False" and if you do... it might cause problems. One way would be to add another hidden (not visible) textbox to hold a value. Say, call it "optButton1Value" Then a simple "If...Then" to assign the value.
If Me.optionButton1 = True then
Me.optButton1Value = "1"
Else
Me.optButton1Value = "0"

 

[lukasgill]

Thanks for your help, i will use that technique.