Hidden control

[Michel Boivin, ing.]

I experience a curious behavior with hidden controls in a Report.

The value of each primary control (CtrlA, CtrlB, CtrlC, CtrlD) is the result
of a function call. These controls (intended to be hidden) are in the Detail
section of the report and their content is printed by secondary controls in
the Bottom of the page section (CtrlAA, CtrlBB, CtrlCC, CtrlDD).

When primary controls (CtrlA, CtrlB, CtrlC and CtrlD) are set to Visible,
everything works fine and the results are what is expected. When I set the
control any primary control to Hidden (required final state), the result is
erronneous.

Any suggestion what to investigate ?

--
Michel Boivin
Cap-Rouge, qc
Mi****@Boivin.net

[Allen Browne]

Bound controls in the Page Footer section are subject to timing, i.e. their
value depends on when Access prepares the section. If the Detail section is
not being printed, the timing of the preparation of the page footer could
well be different.

Can you move the controls into a Group Footer section? Or the Report Footer
section?

Also, any code assigned to Print event of the Detail section may not execute
if the section's PrintSection property is set to No.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Michel Boivin, ing." <mb*****@altavista.net> wrote in message
news:4V********************@wagner.videotron.net.. .

I experience a curious behavior with hidden controls in a Report.

The value of each primary control (CtrlA, CtrlB, CtrlC, CtrlD) is the result of a function call. These controls (intended to be hidden) are in the Detail section of the report and their content is printed by secondary controls in the Bottom of the page section (CtrlAA, CtrlBB, CtrlCC, CtrlDD).

When primary controls (CtrlA, CtrlB, CtrlC and CtrlD) are set to Visible,
everything works fine and the results are what is expected. When I set the control any primary control to Hidden (required final state), the result is erronneous.

Any suggestion what to investigate ?

--
Michel Boivin
Cap-Rouge, qc
Mi****@Boivin.net