Customised message on each report..

Mikk

Registered User.
Local time
Today, 15:00
Joined
Mar 5, 2006
Messages
23
Id like to get a message on each report i print with the message text being entered from a form, without saving the message, would this be possible?

Thanks for you help!
 
I don't usnderstand what you are trying to accomplish! Can you explain in a little more detail. Are you familour with the Page event on reports?
 
Not too familiar with the page events. Basically what i want to do is:

-From an unassigned text box in a form, text is written and then when a button is pressed the text from the form is sent to another text box on a report that is then printed...

Any ideas??
 
Try this on your Report



Taking for granted that you have the message textBox on you Form
name it "txtMessage"

If not create one with no RecordSource

On your Report also create an unbound textBox and name it txtMessageRpt
make it RecordSource as followes

=[Forms].[The Forms Name].[txtMessage]

This will bring the Message on to the Printed Report.

Hope this helps
 
Thanks for the reply three crow, i'd already done as suggested but when i preview it the box comes up with #Name?, maybe it will change when it prints but as i have no printer at the moment, i cant tell.... Any input??

Mikk
 
Can you attach a zipped file of you dataBase.

100k or smaller
 
Make sure you dont close your form first before you print your report or you will not be able to resolve the txtfield on your form.
 
The file is way too big to attach, it doesnt matter guys, i'll list it as a limitation for my project, thanks very much for the help tho! much appreciated!
 

Users who are viewing this thread

Back
Top Bottom