Print Preview missing unbound data

[MarkAgain]

Good afternoon,

I have a Access report that works as expected when opening it with: DoCmd.OpenReport "PrintReportFront", acViewReport ...

When I open the same report with: DoCmd.OpenReport "PrintReportFront", acPreview ...



the unbound textbox that I fill in with VBA are blank. I'm using the VBA to convert a number saved in a bound textbox into the text version of that number (10 becomes Ten).

I have two questions.

1. Is this normal behavior?
2. Is there a way to have the unbound textbox filled in with VBA when opening the report in Print Preview?

Thank you, Mark

[ranman256]

The report data comes from a query,which comes from a table.
unbound is not in a table.
but in the query ,you can load the unbound box using the full path name:
forms!fMyForm!txtBox1

sometimes it wont show, so under this path,choose Expression,instead of GroupBy.

[pbaldy]

Also, the event you used can make a difference. There are events that fire in preview but not in report, and vice versa.

[MarkAgain]

Also, the event you used can make a difference. There are events that fire in preview but not in report, and vice versa.

Thank you for the reply.

I'm sorry. I'm confused. Im not using a query. The data for the unbound text box is entered using VBA from a table during the on load event. The VBA takes the value in a bound text box (shows on the report in both viewreport and preview) and converts the value into a spelled out number. This number (say "Ten") is entered into the unbound textbox. I tried using the on current as well with no difference. Sorry I don't have a better grasp on this.

Thank you, Mark

[pbaldy]

I'm confused because I didn't mention queries. I use the format event of the appropriate section for preview, the paint event for report view.

[MarkAgain]

Sorry about that. The query was in response to the post by:
ranman256

[pbaldy]

Did you try changing the event(s) used? Can you attach the db here?

[MarkAgain]

Did you try changing the event(s) used? Can you attach the db here?

Thank you for the reply.

I tried on load and on current events with no changes. I can't upload or even take the DB or code out of the office.

Thank you, Mark

[pbaldy]

I tried on load and on current events with no changes. I can't upload or even take the DB or code out of the office.

Yes, and I suggested: "I use the format event of the appropriate section for preview, the paint event for report view."