A2002: Calculated control in subreport not printing

[Josh Nikle]

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

[Larry Linson]

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" <jn********@yahoo.com> wrote in message
news:20**************************@posting.google.c om...

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

[Josh Nikle]

Thanks, Larry. That solution worked just fine.

-Josh
"Larry Linson" <bo*****@localhost.not> wrote in message news:<O9***************@nwrddc02.gnilink.net>...

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" <jn********@yahoo.com> wrote in message
news:20**************************@posting.google.c om...

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