[AccessD] Option Group on Report

McGillivray, Don [IT] Donald.A.McGillivray at sprint.com
Mon Feb 5 13:01:27 CST 2007


Try - 

=Choose(OptionGroupValue,"Go","No Go","N/A") as the data source for the control on your report.

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software
Sent: Monday, February 05, 2007 9:55 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Option Group on Report

One simple way is to put a bit of code in the Format event and do an
if...then putting the right word into an unbound textbox on the report.

You could also pull the caption off of the label associated with the option
button in the calling form.

And there's probably a way with an IIf in the query, if you're using a query
as the record source for the report, to convert the value into a word.  (Are
there nested Iifs?)

Rocky 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia
Sent: Monday, February 05, 2007 9:39 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Option Group on Report

I have an option group on a form. How do I get the related word from the
selected option to show on a report?

 

Choices for Option group

1- Go

2 - No Go

3 - N/A

 

The report needs to show the words "Go", 'No Go" or "N/A" not the number (1,
2, or 3).

 

Virginia

 

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.25/669 - Release Date: 2/4/2007
9:58 PM
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list