Printing Text (1 Viewer)

[tinker]

Hiya,
I should really know this but ive got a text box which is used as a notes field. I then want to have a cmd button underneath, which is used to print the text in the textbox to the printer. I dont want to use docmd pintout because this prints the whole form, and i dont want to print the other controls on the form. Is there the abibilty to print by passing the string that you want to print e.g print txtnotes.text

Thanks for any help

 

[Rich]

Use a report with the Open Report method

 

[tinker]

Hello,
I was thinking that, but the record would have to be saved before the notes contents would appear on the report( beacuse the report would point to the table or a query based on a table). No doubt our users would be complaining that to print you have to save it first. Hope ive made sense. Thanks, ill use a report as me solution then.

Cheers

 

[Pat Hartman]

You can save the current record just before you open the report.

DoCmd.RunCommand acCmdSaveRecord

 

[Autoeng]

Or you could create a report with a text box that the control source is "=[Forms]![yourform]![yourformtextbox]". This method does not require that the record is saved.

Autoeng