Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi there and welcome
This is to early in the process to do control formating
I would put the code in the On Open event of your report and it should then run
If you have any difficulties, please let me know
There is no On Open event in the detail section of a report. I am an experienced VBA programmer and iknow what I am doing. In other versions of ACCESS I have used the On Format event to format my reports very effectively. I just can't get it to work in ACCESS 2010. Is there somewhere in teh program that one can turn On or Off the event actions on a report?
no you cant turn it on and off, but have you tried on the on open?
There is no "On Open" event in the detail properties of a report! Where is the On open you are talking about?
on the properties of the report itself, click in the top right of the report to get to this
On Open is only good if one wants to format a control the same way for each occurrence of the report details. In the past I used the On Format to conditionally format the controls in each occurrence of the report detail. For example if the value of a control is zero I may wish to make the visible property false. In Access 2010 the event On Format doen't appear to be active. I have put in code with errors and I have set beakpoints in the code - they were not noticed by the program. Why????
The on format doesnt work in the Report view. but only in the Preview or Normal views.
this may be why it is not running for you
Thanks for your help! I will use you again I'm sure. Can I request you personally next time?
yes you can
did it work?
to request me personally, just click on my name and ask a question
and please remember to click on accept
Yes it works in Print Preview - I didn't see a normal view just "Report', "Layout", "Design" and "Print Preview". What is hour name? I will accept and click it.
10-4 and thanks