Reports

mamfa

New Member
Joined
Jun 23, 2006
Messages
25
how do i make reports come to the front of the screen so that any open forms will disappear behind them?

for a form i select "pop up" but that does not seem to be there for any reports

thanks
Samantha
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

MyBoo

Board Regular
Joined
Aug 9, 2006
Messages
217
One way -In the On Open Event of the report, add:

DoCmd.Maximize

(but this is ugly)


Another way - Size your forms and reports so that they are all the same size (takes a little work to do this) and center them.

Another way - Use code to HIDE/UNHIDE forms that are in the background. (visible = false), (visible = true)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,041
Messages
5,545,685
Members
410,697
Latest member
srishtijain0708
Top