Option Button String value

[grenee]

Good Day all,

My frame name is "Frame1" with Option buttons "Circle" and "Square"; My code line : Name = me.Frame1
however "Name" get a value of 1 or 2 depending on the selection

Can anyone tell me how I can get a return of the String Values instead of the Numeric values.

 

[arnelgp]

you can't, you have to manually do it, ie:
if me.Frame1.Value = Null
Name = Null
else if me.Frame.Value = 1
Name = "Circle"
Else
Name = "Square"
End if

 

[Minty]

Name is a reserved word in Access - I would use something else like txtName
See here for a list https://support.microsoft.com/en-us/kb/286335

 

[grenee]

Thanks for the guidance; saved me trying so hard to find the solution. It worked but I used a case statement.