Prev: Report Detail - How do I either anchor Lines or box
Next: Find Breaks in Data Ranges - Follow-up
From: Galla on 8 Jul 2008 14:42
I have an option group on my report that I would like to become visible
depending on some value.

I have set up the following in Report_Open():
Me.fratest.Visible = True

The problem is that the statement executes, but the option group doesn't
become visible. Any ideas what could be wrong?

Thank you.
From: fredg on 8 Jul 2008 16:07
On Tue, 08 Jul 2008 14:42:58 -0400, Galla wrote:

> I have an option group on my report that I would like to become visible
> depending on some value.
>
> I have set up the following in Report_Open():
> Me.fratest.Visible = True
>
> The problem is that the statement executes, but the option group doesn't
> become visible. Any ideas what could be wrong?
>
> Thank you.

What is the criteria that determines when the [fratest] is visible or
not.
Anyway, the report's open event is too early. To just make it visible
use the Report Header Format event (assuming there is some reason why
you set the visible property to False in the first place).
If there is criteria in the detail section, for exxample, use the
Detail Format event:
Me![fratest].Visible = Me.[SomeField] = somevalue
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
From: Galla on 8 Jul 2008 16:42
Hi Fred,

I use dlookup to find out the value of somefield:
If somefield = 1 I need to display fratest1
if somefield = 2 I need to display fratest2


I have followed your suggestions and tried using the report header
format and the detail format, but fratest (1 or 2) still doesn't become
visible. fratest, by the way, is in the detail section.

For example, I used the following in the detail format without success:
Me.fratest1.Visible = Me.somefield = 1


Thanks for your help.


fredg wrote:
> On Tue, 08 Jul 2008 14:42:58 -0400, Galla wrote:
>
>> I have an option group on my report that I would like to become visible
>> depending on some value.
>>
>> I have set up the following in Report_Open():
>> Me.fratest.Visible = True
>>
>> The problem is that the statement executes, but the option group doesn't
>> become visible. Any ideas what could be wrong?
>>
>> Thank you.
>
> What is the criteria that determines when the [fratest] is visible or
> not.
> Anyway, the report's open event is too early. To just make it visible
> use the Report Header Format event (assuming there is some reason why
> you set the visible property to False in the first place).
> If there is criteria in the detail section, for exxample, use the
> Detail Format event:
> Me![fratest].Visible = Me.[SomeField] = somevalue
From: Galla on 9 Jul 2008 13:33
Thanks for your help, Fred.

I tried again, executing the statement under the detail format event and
it worked! I'm not quite sure what was wrong the first I tried, but it's
working now.



fredg wrote:
> On Tue, 08 Jul 2008 14:42:58 -0400, Galla wrote:
>
>> I have an option group on my report that I would like to become visible
>> depending on some value.
>>
>> I have set up the following in Report_Open():
>> Me.fratest.Visible = True
>>
>> The problem is that the statement executes, but the option group doesn't
>> become visible. Any ideas what could be wrong?
>>
>> Thank you.
>
> What is the criteria that determines when the [fratest] is visible or
> not.
> Anyway, the report's open event is too early. To just make it visible
> use the Report Header Format event (assuming there is some reason why
> you set the visible property to False in the first place).
> If there is criteria in the detail section, for exxample, use the
> Detail Format event:
> Me![fratest].Visible = Me.[SomeField] = somevalue
 | 
Pages: 1
Prev: Report Detail - How do I either anchor Lines or box
Next: Find Breaks in Data Ranges - Follow-up