Cdogg
05-21-2001, 01:05 PM
I have text boxes that are unbound that I use for calulating and I want to print them with the record but don't want to save (30 boxes). But when I press the print button it clears the boxes. Is there anything I can do.
|
View Full Version : Touble printing unbound text boxes Cdogg 05-21-2001, 01:05 PM I have text boxes that are unbound that I use for calulating and I want to print them with the record but don't want to save (30 boxes). But when I press the print button it clears the boxes. Is there anything I can do. boblarson 05-21-2001, 03:06 PM Set up a Report that you can print instead of printing the Form. Use the same query to bind the report as you do the form and then include a text box on the Report for every named text box on your form. As long as the form stays open when you print the REPORT, you should be able to get what you need. (Forms are not optimized for printing, Reports are, so for printing, I think it's usually best to create a report, even if it's almost identical to your Form as you can format things to print the way you want.) ElsVanMiert 05-21-2001, 11:21 PM Bob is right, you definitely need a report. Since it can not be based on table data you need to use the OnOpen event and write code like: dim f as form set f= forms!YourFormName me!CustomerName =f!CustomerName me!TotalNumber=f!Totalnumer me!TaxDeduction=f!TaxDeduction ATTENTION: Check for empty fields on the form and inform the client if there is nothing to be printed. Furthermore, cancelling a report will cause a (trappable) runtime error in the form module. |