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.
Touble printing unbound text boxes
- Thread starter Cdogg
- Start date
boblarson
Smeghead
- Local time
- Today, 15:50
- Joined
- Jan 12, 2001
- Messages
- 32,059
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.)
(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
Registered User.
- Local time
- Today, 23:50
- Joined
- Dec 14, 2000
- Messages
- 152
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.
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.
