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

Problem getting duplicated unbound textboxes to print

P: n/a
Using A2K. I have a series of unbound textboxes on a report. I made a
duplicate of these textboxes (Edit...Duplicate) to make a new series,
then put this new series on another report. But I can't get the
duplicated textboxes to print their values. The first series prints
fine. Any ideas? Thanks for any help or advice.

May 23 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
did you bind the fields to a rowsource?

May 24 '06 #2

P: n/a
"EManning" <ma**********@hotmail.com> wrote
Using A2K. I have a series of unbound textboxes on a report. I made a
duplicate of these textboxes (Edit...Duplicate) to make a new series,
then put this new series on another report. But I can't get the
duplicated textboxes to print their values. The first series prints
fine. Any ideas? Thanks for any help or advice.


By my definition, an _unbound_ Text Box is one that does not have anything
in its ControlSource. Therefore, the only option for it having data to print
is that a calculation is performed in VBA code in one of the events for the
particular report section... OnFormat, OnRetreat, or OnPrint. As you have
not discussed copying such VBA code calculations to the new report along
with the TextBox Controls, it does not seem surprising that when you copy
them to another report, they do not print.

A _bound_ Control will normally have a reference to a Field in the Table,
Query, or SQL Statement that is the RecordSource for the Report, and will
automatically obtain its value there. Some also regard _calculated_ Controls
as being "bound" -- these have an Expression in their Control Source that
provides the value to be displayed or printed.

If this is not sufficient to point you in the right direction, please
clarify with detail, and perhaps someone will be able to assist you.

Larry Linson
Microsoft Access MVP
May 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.