By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,807 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,807 IT Pros & Developers. It's quick & easy.

Option Group: Values only nummeric, how to perform for all characters?

P: n/a
I created an Option Group (go to Design View > Toolbox) and want the
values to be filled in a present table.

How to make it possible that not only nummeric values can be given, but
also names?

Bart

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 13 Jul 2005 20:15:25 -0700, AA Arens wrote:
I created an Option Group (go to Design View > Toolbox) and want the
values to be filled in a present table.

How to make it possible that not only nummeric values can be given, but
also names?

Bart


An Option Group's value can only be a Number.
To store the Number value in a table, bind the Option Group to a field
in the table.

To display a text equivalent to the number, you can use an unbound
control in a form or report.
Set the control's control source to:
=Choose([OptionGroupName],"Text1","Text2",Text3")

You can also use an IIf() statement:
=IIf([OptionGroupName]=1,"Text1",IIf([OptionGroupName]=2,"Text2,"Text3))
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.