Full Version: Open form without Scroll Bars
UtterAccess Forums > Microsoft® Access > Access Forms
EssKayKay
Hello,
Is there a way to turn off Scroll Bars, Record Selectors and Navigation Buttons when a form opens via clicking a button on a previous form? I know how to turn them off by default. Howver, I open this form with numerous other options, some of which I want the controls active.
Here’s what I tried coding on the first forms button (to no avail):
DoCmd.OpenForm "frmBMarks", , , , acFormAdd, , OpenArgs:="BMarks”
Forms![frmBMarks]!ScrollBars = False
Forms![frmBMarks]!RecordSelectors = False
Forms![frmBMarks]!NavigationButtons = False
Thanks,
SKK
trapperalexander
I think you are on the right track with the openArgs, but I would place the code that sets the form properties on the FormLoad event of the form that you are opening. ie:
aircode)
CODE

if openArgs = "BMarks" then
me.scrollBars = false
etc...

HTH
EssKayKay
Excellent, that did it.
Thanks again...
SKK
trapperalexander
welcome, glad to assist. Good luck with your project.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.