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

Option groups and reports

P: n/a
Hello all, i'm a new user in this group and was wandering if anyone could
assisst me with a problem:

I have a form with option groups within it outputig their results to a table
called tblTNAform, with contain a very, very large number of fields linked
to option groups.
My problem is that i wish to display these results as text, not numbers,
and i've run out of ideas. The results of the form may be stored as a number
in the tables but must display as text in the report.

P.S. My VBA is not so good, so any code must be shown in an idiot-freindly
way!
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Sun, 18 Apr 2004 20:56:34 +0000 (UTC), Y Plas wrote:
Hello all, i'm a new user in this group and was wandering if anyone could
assisst me with a problem:

I have a form with option groups within it outputig their results to a table
called tblTNAform, with contain a very, very large number of fields linked
to option groups.
My problem is that i wish to display these results as text, not numbers,
and i've run out of ideas. The results of the form may be stored as a number
in the tables but must display as text in the report.

P.S. My VBA is not so good, so any code must be shown in an idiot-freindly
way!


As you have found, an Option Group value is a number.

To display the OptionGroup's value as text in a report, simply use an
unbound text control.
With just 3 options:

=IIf([OptionGroupField] = 1, "TextA",IIf([OptionGroupField] = 2,
"TextB","TextC"))

If the group has many more options you could use Switch() or Choose()
in an Access Control Source, or Select Case in VBA code to convert the
number value to text.

Look up Switch(), Choose(), and Select Case in VBA Help.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #2

P: n/a
On Sun, 18 Apr 2004 20:56:34 +0000 (UTC), Y Plas wrote:
Hello all, i'm a new user in this group and was wandering if anyone could
assisst me with a problem:

I have a form with option groups within it outputig their results to a table
called tblTNAform, with contain a very, very large number of fields linked
to option groups.
My problem is that i wish to display these results as text, not numbers,
and i've run out of ideas. The results of the form may be stored as a number
in the tables but must display as text in the report.

P.S. My VBA is not so good, so any code must be shown in an idiot-freindly
way!


As you have found, an Option Group value is a number.

To display the OptionGroup's value as text in a report, simply use an
unbound text control.
With just 3 options:

=IIf([OptionGroupField] = 1, "TextA",IIf([OptionGroupField] = 2,
"TextB","TextC"))

If the group has many more options you could use Switch() or Choose()
in an Access Control Source, or Select Case in VBA code to convert the
number value to text.

Look up Switch(), Choose(), and Select Case in VBA Help.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #3

P: n/a

"fredg" <fg******@example.invalid> wrote in message
news:sm****************************@40tude.net...
On Sun, 18 Apr 2004 20:56:34 +0000 (UTC), Y Plas wrote:
Hello all, i'm a new user in this group and was wandering if anyone could assisst me with a problem:

I have a form with option groups within it outputig their results to a table called tblTNAform, with contain a very, very large number of fields linked to option groups.
My problem is that i wish to display these results as text, not numbers, and i've run out of ideas. The results of the form may be stored as a number in the tables but must display as text in the report.

P.S. My VBA is not so good, so any code must be shown in an idiot-freindly way!


As you have found, an Option Group value is a number.

To display the OptionGroup's value as text in a report, simply use an
unbound text control.
With just 3 options:

=IIf([OptionGroupField] = 1, "TextA",IIf([OptionGroupField] = 2,
"TextB","TextC"))

If the group has many more options you could use Switch() or Choose()
in an Access Control Source, or Select Case in VBA code to convert the
number value to text.

Look up Switch(), Choose(), and Select Case in VBA Help.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.


Thanks Fred, worked a treat!
Nov 12 '05 #4

P: n/a

"fredg" <fg******@example.invalid> wrote in message
news:sm****************************@40tude.net...
On Sun, 18 Apr 2004 20:56:34 +0000 (UTC), Y Plas wrote:
Hello all, i'm a new user in this group and was wandering if anyone could assisst me with a problem:

I have a form with option groups within it outputig their results to a table called tblTNAform, with contain a very, very large number of fields linked to option groups.
My problem is that i wish to display these results as text, not numbers, and i've run out of ideas. The results of the form may be stored as a number in the tables but must display as text in the report.

P.S. My VBA is not so good, so any code must be shown in an idiot-freindly way!


As you have found, an Option Group value is a number.

To display the OptionGroup's value as text in a report, simply use an
unbound text control.
With just 3 options:

=IIf([OptionGroupField] = 1, "TextA",IIf([OptionGroupField] = 2,
"TextB","TextC"))

If the group has many more options you could use Switch() or Choose()
in an Access Control Source, or Select Case in VBA code to convert the
number value to text.

Look up Switch(), Choose(), and Select Case in VBA Help.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.


Thanks Fred, worked a treat!
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.