Please help, simple radio button code wont work and I cant work out why (1 Viewer)

andyj2k1 · Feb 25, 2007

Hi folks. Ive got a simple bit of code saying..

Dim score As Integer
score = 0

If Option16.Value = 1 Then
score = score + 1
end if

But i keep geting an error message saying "you entered an expression that has no value"

Anyone got any ideas, this is really frustrating me now!

Rickster57 · Feb 25, 2007

option

the option value = -1 for true and zero for false.

OOPs, I'm thinking of a checkbox. Sorry about that.

unclejoe · Feb 26, 2007

Hi,

It should be "Option16.OptionValue".

This control ("Option16.Value") does not work in VBA.

You can set the OptionValue to 1,2,3...etc.

HTH

andyj2k1 said:
Hi folks. Ive got a simple bit of code saying..
Dim score As Integer
score = 0
If Option16.Value = 1 Then
score = score + 1
end if
But i keep geting an error message saying "you entered an expression that has no value"
Anyone got any ideas, this is really frustrating me now!

RuralGuy · Feb 26, 2007

Andy,
Where do you have that code? Is Option16 an OptionGroup control?

andyj2k1 · Feb 26, 2007

Thanks for the help guys, its just a option box (radio button) on a form. Still cant get it to work

unclejoe · Feb 26, 2007

Hi,

Then, "Option.Value" should work.

"you entered an expression that has no value"

The code you gave might not come from it. Is there something else in the code? In the VBA editor, where did the line stop?

andyj2k1 said:
Thanks for the help guys, its just a option box (radio button) on a form. Still cant get it to work

andyj2k1 · Feb 26, 2007

Thanks for all your help!!!

Problem solved

Phew

Please help, simple radio button code wont work and I cant work out why (1 Viewer)

andyj2k1

New member

Rickster57

Registered User.

unclejoe

Registered User.

RuralGuy

AWF VIP

andyj2k1

New member

unclejoe

Registered User.

andyj2k1

New member

Similar threads

Users who are viewing this thread