Phil
asked on
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.
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.
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.
Jim.
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.
Jim.
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
Is it possible to insert page breaks and line feeds within this rich textbox?
ASKER
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.
I can open up another Ask if you'd prefer.
<< 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.
Jim.
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.
Jim.
ASKER
Jim answered my question and I have a perfect resolution to the question asked. Thank you so much Jim!!!
Jim.