"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