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

Hidden control

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


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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.