By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,501 Members | 831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,501 IT Pros & Developers. It's quick & easy.

A2002: Calculated control in subreport not printing

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.