Option group doesn't become visible

  • Thread starter Thread starter Galla
  • Start date Start date
G

Galla

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.
 
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.
Click to expand...

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
 
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.

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.
Click to expand...

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
Click to expand...
 
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.


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.
Click to expand...

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
Click to expand...
 
Back
Top