Report question

  • Thread starter Thread starter mosquitooth
  • Start date Start date
M

mosquitooth

Hi

in one of my access reports, I created a textbox, that
shall be filled with data, when the report appears. The
data to show is stored in a public/ global var that is
declared in a module. Now, I tried to implement this in
the Report_Open handler as following:

TextBox1.SetFocus
TextBox1.Text = myglvar

But all that happens is, that access denies this two
expressions.

How can I solve this??

mosquitooth
 
Open the report in design mode. Open the properties window for the textbox.
Look for the control source property. Add something like the following as
the textbox's control source:

=get_myglvar()

NOTE: you will first have to create a function in a code module that
returns the value of your global. Since you've already declared the
variable in a module, just add a new function (get_myglvar()) that returns
it. The reason you'll need to do this is because you have to use (if I
remember correctly) a function, not a public variable, in a control source.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top