Hiding Command Buttons in Reports?

[Rosier75]

Hello all. Here's my latest question. Is there a way make visible/hide a command button on an Access report based on the value of another field on the report?



Essentially, if Text1 is null, Command2.Visible = No. If Text1 is not null, Command2.visible = Yes

I've seen articles on the internet that address this with Forms but can't find a solution for reports.

Thanks

[June7]

Code in Format event is where to place this kind of code. However, Format event executes only for PrintPreview or direct to printer. Buttons cannot be clicked in PrintPreview anyway. You might just be out of luck. Reports are not intended to be 'action' objects.

[Rosier75]

Thanks for the info.

[A S MANN]

On load event of Report
Use VBA

if IsNull([Text1]) Then
Me.Command2.Visible = False
Else
Me.Command2.Visible = True
End If
Try this

[Rosier75]

Thanks for the input. That didn't do the trick. Will probably have to rethink my approach on this.

Thanks again

[A S MANN]

Can you explain what was the problem. I am using above approach in many of my form and report and they works fine. Can you share a copy of Database with problematic report to identify the source of error.
Thanks

[June7]

I did some testing and can't get code to work for report. The button shows in ReportView and does not show in PrintPreview regardless of the code.

Why even need button on report?

[roaftech]

I stand to be corrected, but IIRC the report doesn't open until the end of the Report_Open sub and therefore the fields in your report don't actually exist at the time when you are trying to make the comparison.

I spent several hours trying to get some code like yours to work before I remembered having seen the sequence explained somewhere. In my case, I was trying to hide the '#Error' in the report footer totals if the data was outside the specified period, by comparing the latest valid date in the data with the date specified in the filter. What I wanted was a "After_Open" event but there isn't one for reports.

I did resolve it, but only by comparing appropriate fields on the forms from which the report is generated. ('Me' is the report)

    If Forms!LatestRecord.Date < Forms!DateSelector.FirstDate Then
        Me.TotalItems.Visible = False
    Else
        Me.TotalItems.Visible = True
   End If

The first form is used only for this comparison, but you do have to remember to open it (visible=False) before the main report will recognise it.
The second form builds a filter before opening the report.
In your case, you need to check the data that 'Text1' reads from.

BTW, I do think that June7's last question is a valid one. Might be better to set up a parameter form

[June7]

roaftech, code behind report can use data from the report RecordSource. I do this to set visibility of some controls. Example from Detail section Format event:

    If IsNull(![207.Method]) Then
        .linFracture.Visible = True
    End If
    If IsNull(![605.method]) Then
        .linMoisture.Visible = True
    End If

These reports open to a single record.

I couldn't get anything to manage the command button.