Open Report Design View As Hidden

  • Thread starter Thread starter Guest
  • Start date Start date
Try this code

DoCmd.OpenReport "ReportName", acViewDesign
Application.Reports("ReportName").Visible = True
 
Are you sure about this option?
I didnt get any acHidden option on the OpenReport command line.
 
Did you have any problem using my suggestion?
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
 
It works for me, in Access 2003. Perhaps it did not in earlier versions - I
don't have an earlier version installed on this PC, so can't test that right
now.

If it isn't supported in your version of Access, try Ofer's suggestion of
setting the Visible property - it should work too.
 
Ofer said:
Are you sure about this option?
I didnt get any acHidden option on the OpenReport command line.
On the form Yes, but not in the report
Click to expand...

It's most definitely there in Access 2002, as I tested it before
posting.
 
You right
2003 has it
2000 doesn't have it
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
 
It's not in 2000 either
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



Jeff Conrad said:
Not there in 97.

DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:
What version of Access are you using? It's there in Access 2002.
Click to expand...
Click to expand...
 
Back
Top