| re: A2002: Calculated control in subreport not printing
Thanks, Larry. That solution worked just fine.
-Josh
"Larry Linson" <bouncer@localhost.not> wrote in message news:<O92Ob.4021$9U6.35@nwrddc02.gnilink.net>...[color=blue]
> There are some differences between main reports and reports embedded in
> Subreport Controls, but without some specifics, it would be difficult to
> guess whether, or which, one of those is involved.
>
> It would be good to create this as a Calculated Field in the Query on which
> the Report embedded in the Subreport Control is based, and then use that as
> the ControlSource of a TextBox. That would seem to me to be less likely to
> run afoul of differences.
>
> Larry Linson
> Microroft Access MVP
>
>
> "Josh Nikle" <jnikle2100@yahoo.com> wrote in message
> news:20ea5371.0401151210.4591d63a@posting.google.c om...[color=green]
> > I have a subreport that displays the addresses of suppliers. Its
> > source table has fields for the name, street, city/state, and ZIP code
> > for easier querying. However, for display purposes, I put the
> > city/state and ZIP together and put that value in txtCityAndState.
> > When I run the report, the print preview looks perfect. When I print
> > it, though, txtCityAndState is blank. I've tried putting the same
> > code I used to fill this textbox in the different events of both the
> > main and sub reports without success. I've done things like this
> > before on main reports, so it must be something special with
> > subreports? Any help is greatly appreciated.
> >
> > -Josh[/color][/color]
| 
