option bottoms

[gasim]

I have three options bottoms on the form their value are
1,2,3 I would like my report to which I use it to print
pre-printed form to print "X" value instead of 1,2,3
is that possible , please help

 

[Duane Hookom]

A third option is to use the Choose() function. This works great when
options are number 1,2,3,...
=Choose([OptionGroupName],"AAAA","BBBB","CCCC")
Normally, I would place three records in a table with the number and
description. This would be much more flexible.
--
Duane Hookom
MS Access MVP

In the report, add an unbound control.

As control source of this unbound control:
=Switch([OptionGroupName]=1,"AAAA",[OptionGroupdName] =
2,"BBBB",[OptionGroupName]=3,"CCCC",IsNull([OptionGroupName]),"Nothing
selected")

Or you can use code.

Name an unbound control "ShowOption".

Code the Section's (Detail?) Format event:
Dim strString as String
Select Case OptionGroupName
Case is = 1
strString = "AAAA"
Case is = 2
strString = "BBBB"
Case is 3
strString = "CCCC"
Etc.
Case Else
strString = "Nothing selected"
End Select
[ShowOption] = strString


--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

I have three options bottoms on the form their value are
1,2,3 I would like my report to which I use it to print
pre-printed form to print "X" value instead of 1,2,3
is that possible , please help