Printing direct in Access 97 module

[Michael]

C'mon guys - please help me with this before I bore you to death with it!!!

I have a function in an Access 97 database, which I run via a macro.

I want to print some values directly from this function to the printer. Can I do this?

If I can then I can't seem to find a way! If not then do I have to create a temporary recordset and use a report to do my printing?

Can I get hold of the printer object?

This (apparently) simple problem is driving me crazy!!!

Thanks in advance

[Clunietp]

I was perusing thru the Access libraries, and I don't see a printer object similar to that in the VB libraries....I suppose you could create a temporary form/report at runtime, or create a COM object in VB and call it from Access, that could do your printing for you.....