In a report -Using a calculated field in Select Case causes Error

[Klatuu]

If your format is 2002/2003 and you are doing your development in 2007, you
may get strange results like that. the general rule is do your development
is the version of the format. In addition, being on Vista, you don't know
what might happen

I haven't installed Vista yet. I don't even have a computer that will
support it. My brother bought a lap top that came loaded with Vista and
became very frustrated, so he bought a different disk for it and loaded it
with XP.

 

[Maverick]

As another test I put the code in the On Click event and it works perfectly
fine.

 

[Maverick]

I figured out why the On Format event wasn't triggering. 2007 has an
additional report view than prior versions. I am looking at the report in
this new view. When I open the report in Print Preview, the code fires.


I guess I'm going to have to have the report open in Print Preview instead
of Form View in order to make this work. I really would have liked this code
to trigger when the report opened so that it worked no matter what view.


Oh well. It's always good to stop the bleeding, no matter what kind of wound.


Thanks for sticking with me.