Write text programatically

  • Thread starter Thread starter Isaack Rasmussen
  • Start date Start date
I

Isaack Rasmussen

Hello,

I'm trying to make a report that will output data from Database
tables. Doing it linearly is easy enough.
But I want more control over the grouping and use conditional
statements in the loop.
I have not been able to figure out how to do this in the Detail
segment of a Report. So I then tried to use VBScript, but using the
function "print" doesn't work as specified in the help files.

I'm running on Access 97 and the error I actually get is,
Runtime error: 2158
Application-defined or Object-defined Error

And the line is my,
Me.Print ("Testing myself")

Me seems to work fine, but not in combination with Print.

I'm sure this has been asked before, but I have not been able to find
anything as my keywords appears to be too generic.

Thanks in advance,
 
Unless it's changed recently, forms and reports don't have a Print method:
only the Debug object does (Debug.Print writes to the debug window)
 
Hello Douglas,

Thanks for the reply. So does it mean that there's no way to
programatically write text on the report?

Isaack
 
No, that's not the case. You can, for example, put a text box on your report
and use VBA to write to the text box. Let's say you've added a textbox
txtScratchpad to your report. You'd then use:

Me!txtScratchpad = "Testing myself"
 
Douglas J. Steele said:
No, that's not the case. You can, for example, put a text box on your report
and use VBA to write to the text box. Let's say you've added a textbox
txtScratchpad to your report. You'd then use:

Me!txtScratchpad = "Testing myself"
Click to expand...

I'd suggest a copy of Access Developers Handbook. It has a lot of
information about reports that includes most if not all of what has been
requested.
www.bookpool.com has always had the best price.
 
Back
Top