Fields Go Blank On Print Preview

[VariableZ]

Access 2007 SP3 32bit


Windows 7 64bit
Dell Optiplex 790

I have a field in a report that has no control source. Instead, its value is provided via a defined global variable, gblATVsDuringTimePeriod, by the following VBA code in the report's Load event:

ATVsDuringTimePeriod.Value = gblATVsDuringTimePeriod

It works fine, and any fields based on the value also work fine... until you Print Preview the report, at which point the field and any fields calculated off of it go blank. If I just Print instead of Print Preview, everything prints fine, but if I Print Preview first, the fields are blank, even on the printed document.

I tried putting the code into the Open event, but Access didn't like that.

Is there anything that I can do to stop the fields from going blank, short of telling the users not to look at the print preview?

[burrina]

We would need to see some code and or some screenshots to help with this!

[VariableZ]

Ok, I think I just figured this out. Instead of setting the textbox's value in the Load or Open events, I put

Me.ATVsDuringTimePeriod = gblATVsDuringTimePeriod
In both the Paint and Format events of the section that the textbox resides in. The Format event makes the value show up in the Print Preview and Paint makes it show up in the Normal View.

Does this seem like a reasonable fix/workaround for this issue, or am I setting myself up for more problems down the road?

I'm including a picture to illustrate the problem I've been having:

[burrina]

Glad to see you got it working. Good Luck with your project.

[VariableZ]

I'll go ahead and mark this as closed, then.

EDIT:
I just found out that I can create a function as so:

Public Function ATVsDuringTimePeriodFunction() As String
ATVsDuringTimePeriodFunction = gblATVsDuringTimePeriod
End Function

And call the function as the control source of the Text Box as so:
=ATVsDuringTimePeriodFunction()

And get rid of the Paint and Format functions. I like it a lot better.
This is my first function.