View instead of print

[gabrielr]

Hi all,



I have a Report, that gets populated (in part at least) by data passed to the report_Load() subroutine. The report is launched from a form, with a command button:

DoCmd.OpenReport reportName:="Report1", OpenArgs:=argsStr

However, instead of launching the report to view, it trys to print it right away! How do I get it to preview the report, and not print

[pbaldy]

If you look in help at OpenReport, you'll see there's an argument that controls that. You haven't included it, and the default is to print.

[gabrielr]

I tried what you suggested, and found that acViewReport previewed the report without printing it. However, it also refuses to read the Detail_Format subroutine, and I need that to change the colors of the fonts used based on another variable -

Option Compare Database

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

On Error GoTo Detail_Format_Error

    Dim WasSold As Boolean
    Dim shadedColor As String
    
    WasSold = Check37.Value
    
    shadedColor = "#000000"
    If (WasSold) Then
        shadedColor = "#0072BC"
    End If
    
    Me.Section(acDetail).BackColor = shadedColor
    
    MsgBox "Alert alter!"
    
Detail_Format_Exit:
    Exit Sub

Detail_Format_Error:
    MsgBox "Error " & Err.Number & ": " & Err.Description
    Resume Detail_Format_Exit
    
End Sub

But the subroutine is never called.

[pbaldy]

You want Preview mode, not Report. I think it's acViewPreview. The format events don't fire in Report mode, as you've found (that drove me crazy the first time I ran into it).

[gabrielr]

Thanks pbaldy - the only problem is that I also have to set the row source, and you can't do that in acViewPreview.

The way I'm doing my code is like so:

Form - ReportGenerator
- Has fields to limit report by date, type, etc
- on ReportGenerator.CommandButton1.onClick
- Create string with values (ie 11-02-1999|||true|||true|||etc...)
- DoCmd.OpenReport "MyReport", acViewPreview, , , stringWithArgs

MyReport
- on_load: read string, generate sql string, set row source of report to sql value
- format: read single value, change background color of row based on boolean value, provided by a checkbox on the report that is A) not visible and B) boung to the boolean value in the query

Am I going about this wrong? My goal is to have a form that lets you set the limits (or filter) a report - that report then has to have different colors for different rows based on a field bound to the report query.

[pbaldy]

I'm sure you can set the record source ( I assume that's what you meant) in preview mode. Try the open event rather than the load event. That's where I do it.

[gabrielr]

Ahh, that did the trick! Just had to change

Report1_load to Report1_open

Thanks pbaldy!

[pbaldy]

No problemo, and welcome to the site by the way!