Values in Text Boxes disappear when print preview

[kompkar]

I created a form which loads values into a report.



When the report opens in 'Report' mode - acViewReport - I can see the values I set for the text boxes in the report.

However when I press 'Print Preview', the values in the report disappear and all I can see are the 'label text' for the text boxes I setup in the Report

-
The code in the form that activate the report is

Private Sub Command0_Click()
Dim reportname As New Report

DoCmd.OpenReport "dfsdf", acViewReport, , , acWindowNormal
Set reportname = Reports![dfsdf]
reportname!Text0.SetFocus
reportname!Text0.Text = "sdfsd"
 
End Sub

For this example, the only control on the report is a single text box called "Text0". and the only control on the form is a command button called "Command0"

I'm using MS Access 2007 - MS Office 2007.

The report is not linked to any tables or queries - I've code in the form which access the tables, does the calculations, and loads the final values into various text boxes which I've setup in the report. All works fine - the calculated values get displayed in the various text boxes in the report - but when I click Print Preview, the values disappear and only the labels stay on !

[kompkar]

I've attached the sample DB for you guys to try out - please help - thanks

[RuralGuy]

The method you've chosen for completing the report field is not allowed nor does if work in Preview Mode.

[kompkar]

Thanks - any suggestions how I can accomplish what I'm trying to do - i.e dynamically set values to textboxes in a report and make it available in print preview mode as well !

[RuralGuy]

Putting your code in the Open event of the report might work.

[kompkar]

Tried that suggestion, it did not solve the problem - also tried load event, got focus event, on click event - but nothing worked

[RuralGuy]

I've not seen anyone try and run a report the way you are attempting so I guess I will not be of much help, sorry.

[weekend00]

You can not change any thing in a report after it's open.

You may try to initialze something in the report's event "Detail_Format". But the key point is how to pass value from the form to the report. I have tried many ways I found from internet but none successed (in Access 2003 ). Maybe you have better luck than me.

[RuralGuy]

I have successfully set values on the report in the Open event of the Report passed to the report in the OpenArgs argument. These values were in the header of the report and not the Data Section.

[weekend00]

I tried the OpenArgs again, this time I got the value.

Since the textbox of my report is in Detail section, I could not give value to the textbox in report open event(I think the textbox is not ready yet when open). I need to do in detail_format event.

[RuralGuy]

When I do this I think I create Public variables in the Report and set their value in the OpenEvent and then bind controls in the Detail section to these variables. Just a thought.

[alaric01]

i've got the same problem here. i have unbound text boxes Report Header and Report Section that are suppose to display the exact data as the the textboxes in the form.

it's showing up perfectly in the report view, but shows nothing in print preview

here's my code

txt_jumlah_grand_total = Forms!frm_main_sales_report.txt_jumlah_grand_total.Value
    
txt_total_pembayaran = Forms!frm_main_sales_report.txt_total_pembayaran.Value

i've tried the code in the open and load event of the report. and in the onclick button (in the form) that open up the report.

anyone can show me example of how to use the openargs argument to accomplish this?

thx