Option Group values

  • Thread starter Thread starter Vickie English via AccessMonster.com
  • Start date Start date
V

Vickie English via AccessMonster.com

Hello,

Could anyone help me out here? I have an option group containing 8 items.
Somehow I tried to change the value but Access created them with 1, 2, 3,
4, 5, 6, 7, 8. I'm trying to change the values to 0, 1, 1.5, 2, 2.5, 3, 4,
5. Thanks

VE
 
I don't think you can. I believe option groups can only contain integer
values. You'll have to use some code to apply the value you want for each
option; like if TheOptionGroup.Value=3 then TheFieldValue=1.5
 
I need to change values 1-6 to values 0-5 (all integers). Can someone please
help me with this? If I do need an If Statement, please be specific as to
where I'd enter it since I'm still a novice. Thanks so much!
 
THanks so much! That wasn't painful at all, but changing every value for
every question will be! Thanks again!
 
You change the value of each option button in your option group but clicking
on the properties and changing the option group value in the data tab.
 
Back
Top