Printing a textbox not working?!

Crackers

Registered User.
Local time
Today, 20:19
Joined
May 31, 2002
Messages
36
I have a Form that contains a Textbox (txtSummary) which summarises all information that is contained on that Form. All I want to do is print the textbox only, as a quick reference for other people to look over.
I searched this Forum beforehand to see if the printing of the textbox was possible and found the following advice:

Create a textbox on a Report and for the Control Source of that report put..
=[Forms]![MyFormName]![txtSummary]

but when I view the report I get the error... ?Name
I have checked that all names are correct and they are as far as I can see.
Could somebody please tell me what it is that I am doing wrong.
Thank-you for your help.
 
Is the form still open? It *must* be for this to work. Are you using the name of *your* form instead of [MyFormName]?
 
Crackers,

Create a report using the Wizard, use the same data source as your form and include txtSummary.

If txtSummary is an unbound text box that you have created on the form then you will have to create a report base it on the same source as the form and then copy the txtSummary to the report.

Have a look at my sample;

CusDetails is a concatenation of 5 Different fields, look at the query that is the source for the form.

You will also notice that I have an unbound text box call txtUnbound, that data is not saved but created each time the form loads.

Now have a look at the report and you will see that I have the same unbound text box in the report .

Hope this helps. (.........Go Pies......)
 
Last edited:

Users who are viewing this thread

Back
Top Bottom