Access 2010 report with no Record Source On Format events not executing

I am trying to use Microsoft Access reports to display Rich Textbox data loaded from Excel spreadsheets. The Reports will then converted to multiple PDFs and finally combined into a single PDF. Originally I was trying to use Microsoft Word for this but I couldn't get Word to properly display Rich Textbox data.

I have an unbound Rich Textbox control in the detail section but the On Format event does not execute. I've tried using the textbox in other sections and none of them execute.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Set the reports recordsource such that it will return one record from a table as a work around.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
BTW, I just double checked because if memory served, the events do fire even if the recordsource is blank.

Couple things to be aware of however:

1. You must be doing print preview or print for the events to fire.

2. Make sure the property page is set to [Event Procedure] for the event, and when you click the builder button (...) off to the right, it opens the VBA editor and brings you to your code.

pabrannPresidentAuthor Commented:
Thanks Jim. Ok, I set the recordsource to pick up a value from a field and inserted a bound textbox in the detail section. When I run the report, it shows the work around textbox value properly but the on format event does not execute that should populate the needed rich textbox.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

pabrannPresidentAuthor Commented:
I am just selecting "Report View" to open up the report

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pabrannPresidentAuthor Commented:
Ahaaaa, yes. Print Preview works... Thank you very much!!! I will go ahead and Accept as Solution but I do have a couple other Q's if it's ok with you.

 Is it possible to insert page breaks and line feeds within this rich textbox?
pabrannPresidentAuthor Commented:
What I have been trying to resolve here is to get the rich box to display properly in this dummy work around report. The real report I was working with displayed the data fine but page 1 was blank, and the data displayed in pages 2 through 5.

I can open up another Ask if you'd prefer.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<< Is it possible to insert page breaks and line feeds within this rich textbox?>>

 Good question and I don't know the answer off-hand (I suspect no).   Please ask another question so other people can see.

 Also, it's generally a good idea to have only one question and one answer in a thread, especially when it really doesn't pertain to the title.

pabrannPresidentAuthor Commented:
Jim answered my question and I have a perfect resolution to the question asked. Thank you so much Jim!!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.