Multiple (intentional) prompts in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an application where a good portion of a report is created dynamically
and automatically for the end user. The end user may need to tweak the
report design by moving fields around or adding new text boxes that prompt
for information not stored in a table, but that the end user wants displayed
on the report. Using a form for the prompt information is not an option in
this case, because the end user is not familiar with changing forms and would
not be adept at changing both a form AND a report when the report output
requires a change.

In some cases the end user wants to add numerous prompt fields to the
report, some of which are related in content. The order in which the
prompts pop up at run-time, however, seems random. Is there any way to
dictate the order in which the prompts appear? I have tried naming the text
boxes alphabetically, but that does not work.
Thanks.
Kathy
 
I discovered a way and wanted to share.

One-by-one for each text box that performs a prompt and in the order
you want the prompts to appear:

1) highlight the text box
2) go to the Format menu
3) select Bring to Front

This same technique works for defining the order for tabbing when in
design view.
 
Back
Top