Printing problems with unbound subform data

Dear all,

I am experiencing a problem which is driving me potty and would
appreciate any insights you may have. I am trying to print a
screenshot of a form (essentially) by using a button to run the
following code:
DoCmd.PrintOut acSelection, 1, 1

The problem is that the design of the form prints perfectly, but the
values in the controls are ignored and appear blank on the printout.
The form is fairly complicated and contains some subforms where the
controls are unbound and the values are updated using VBA. I do not
have an option (due to time and complexity) of creating a new set of
reports to do this (as all that is required is a screen dump) and
ideally I would like to print directly from the form (I am
tantalisingly close!)

I do not want to go down the route of using 3rd party software to
utilise a Prnt Scrn command and do not want to either change the design
of the forms or have to create a set of queries / reports. I am fairly
sure that there is a property somewhere on either the main form or the
underlying subform that has been changed by accident that is preventing
me from printing out all data.

If anyone has experienced this problem before or can provide an insight
then that would be really appreciated. Even to know that it is
physically impossible would help!

Many thanks,
Simon

PS The db is being written in ac97 (unfortunately) but the problem is
current in ac2000 and ac2003.

I had this problem also. Best I could do was SHIFT+PRTSCR to copy the
current screen to the clipboard, then switch to WORD, CTRL+V to paste it,
then print.

UpRider

"Simon Livings" wrote in message
ps.com...
Dear all,

I am experiencing a problem which is driving me potty and would
appreciate any insights you may have. I am trying to print a
screenshot of a form (essentially) by using a button to run the
following code:
DoCmd.PrintOut acSelection, 1, 1

The problem is that the design of the form prints perfectly, but the
values in the controls are ignored and appear blank on the printout.
The form is fairly complicated and contains some subforms where the
controls are unbound and the values are updated using VBA. I do not
have an option (due to time and complexity) of creating a new set of
reports to do this (as all that is required is a screen dump) and
ideally I would like to print directly from the form (I am
tantalisingly close!)

I do not want to go down the route of using 3rd party software to
utilise a Prnt Scrn command and do not want to either change the design
of the forms or have to create a set of queries / reports. I am fairly
sure that there is a property somewhere on either the main form or the
underlying subform that has been changed by accident that is preventing
me from printing out all data.

If anyone has experienced this problem before or can provide an insight
then that would be really appreciated. Even to know that it is
physically impossible would help!

Many thanks,
Simon

PS The db is being written in ac97 (unfortunately) but the problem is
current in ac2000 and ac2003.