Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / October 2005

Tip: Looking for answers? Try searching our database.

Setting an unbound `report text box in teh "detail PRINT event"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brad Pears - 31 Oct 2005 18:38 GMT
I have a report where I have an unbound text box as one of the detail line
fields. At time of printing, I want to set that detail line to a value. I
set up my code in the "On Print" event for the detail section to check some
things and then I assign a value to the unbound text box.

However, when the code runs, it errors out stating I can;t set the text box
value because the control I am setting does not currently have focus.

How can I get what I want done?

Thanks

Brad
Rick B - 31 Oct 2005 18:49 GMT
Why are you doing it in the ON PRINT event?  Why not just put the desired
data in the unbound text box and let it load when you open the report?

Signature

Rick B

>I have a report where I have an unbound text box as one of the detail line
>fields. At time of printing, I want to set that detail line to a value. I
[quoted text clipped - 9 lines]
>
> Brad
Brad Pears - 31 Oct 2005 22:00 GMT
Yes, you are correct - there was an easier way - which is basically what you
were describing...

Thanks,  Brad
> Why are you doing it in the ON PRINT event?  Why not just put the desired
> data in the unbound text box and let it load when you open the report?
[quoted text clipped - 12 lines]
>>
>> Brad
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.