Vertical scroll bar missing

[Guest]

I have a form in access that is modal and pop up, border is sizeable. On its
properties I have scroll bars set to vertical only. However, no vertical
scroll bar is showing up when the form is viewed in form view. The form is
taller than the screen, so I need users to be able to scroll down. I've
tried various settings, with no luck. I'm sure its something minor, but can
find nothing in the help to indicate what it might be.
NTE

 

[Ken Snell [MVP]]

Making it a popup, I believe, is the source of your problem. You'll need to
change your approach - either don't make it a popup, or make the form
smaller.

 

[Guest]

Ken,

I set pop up to no, and then rechecked the form in form view. Still no
vertical scroll bar. This form has a tab control as its only control, with
many other controls on each page of the tab control. Would the large tab
control be causing the vertical scroll bar not to appear?
NTE

 

[Ken Snell [MVP]]

A large tab control should not cause vertical scroll bar to not appear. I
have been unable to produce any situation where the vertical scroll bar
doesn't appear, even if I make the form so wide (with no horizontal scroll
bar) that it can't fit sideways on the screen.

Are you sure you have the form's scroll bar set to Vertical?

What default view are you using for the form?
--

Ken Snell
<MS ACCESS MVP>

 

[Guest]

The default view is Single Form. Scroll Bars is set to vertical only. I
have tried it set to Both as well. I suppose what bothers me most is that I
have been using this same form for 4 years with no problems. This year we
added a few fields to our annual report, so I had to add them to the form.
That is the only change I made to the form directly. Maybe I've maxed out
the number of objects that the form can handle? Although why that would
cause a scroll bar problem is beyond me.

Currently, when "documented" the form properties are:
AllowAdditions: True
AllowDatasheetView: False
AllowDeletions: True
AllowDesignChanges: True
AllowEditing: True
AllowEdits: True
AllowFilters: True
AllowFormView: True
AllowPivotChartView: False
AllowPivotTableView: False
AllowUpdating: No
AutoCenter: True
AutoResize: True
BorderStyle: Sizable
Caption: Annual RCW Data Collection
CloseButton: False
Container: Forms
ControlBox: True
Count: 430
CurrentView: 0
Cycle: Current Record
DataEntry: False
DatasheetBackColor: 16777215
DatasheetBorderLineStyle: 1
DatasheetCellsEffect: Flat
DatasheetColumnHeaderU 1
DatasheetFontHeight: 10
DatasheetFontItalic: False
DatasheetFontName: Arial
DatasheetFontUnderline: False
DatasheetFontWeight: Normal
DatasheetForeColor: 0
DatasheetGridlinesBehavior Both
DatasheetGridlinesColor: 12632256
DateCreated: 9/29/2004 8:25:49 PM
DefaultEditing: 2
DefaultView: Single Form
DividingLines: True
FastLaserPrinting: True
FetchDefaults: True
FilterOn: False
FrozenColumns: 1
GridX: 24
GridY: 24
GUID: {guid {1BCBD62E-A141-
HasModule: True
47B7-B624-1C0A2CDA2C30}}
HelpContextId: 0
HorizontalDatasheetGridline 1
Hwnd: 787372
InsideHeight: 6840
InsideWidth: 13245
KeyPreview: False
LastUpdated: 9/29/2004 8:25:49 PM
LayoutForPrint: False
LogicalPageWidth: 9360
MaxButton: False
MinButton: False
MinMaxButtons: None
Modal: True
Moveable: False
NameMap: Long binary data
NavigationButtons: True
OnKeyDown: [Event Procedure]
OnKeyUp: [Event Procedure]
OrderByOn: False
Orientation: Left-to-Right
Owner: admin
Painting: True
PaletteSource: (Default)
Picture: (none)
PictureAlignment: Center
PictureSizeMode: Clip
PictureTiling: False
PictureType: 0
PopUp: False
PrtDevMode: Long binary data
PrtDevNames: Long binary data
PrtMip: Long binary data
RecordLocks: No Locks
RecordSelectors: False
RecordsetType: Dynaset
RecordSource: MostInfo
RowHeight: Default
ScrollBars: Vertical Only
ShortcutMenu: True
ShowGrid: True
SubdatasheetExpanded: False
SubdatasheetHeight: 0
TimerInterval: 0
UserName: admin
VerticalDatasheetGridlineSt 1
ViewsAllowed: Form
Visible: False
WhatsThisButton: False
Width: 12735
WindowHeight: 7545
WindowLeft: 780
WindowTop: 2175
WindowWidth: 13665

 

[Guest]

When documenting the old form and the revised form, these are the properties
that are different:

Properties Old New
AllowDatasheetView: TRUE FALSE
AllowPivotChartView: TRUE FALSE
AllowPivotTableView: TRUE FALSE
AutoCenter: FALSE TRUE
Count: 377 430
Hwnd: 459318 787372
InsideHeight: 8700 6840
InsideWidth: 15060 13245
Moveable: TRUE FALSE
OrderByOn: TRUE FALSE
PopUp: TRUE FALSE
ViewsAllowed: Both Form
Visible: TRUE FALSE
WindowHeight: 9405 7545
WindowLeft: -90 780
WindowTop: -375 2175
WindowWidth: 15480 13665

I will try setting all the setting the same as the old form as on the new
form (except count, I think that is # of controls?) and see if I get the
scroll bar back. I will also try creating a new blank form and moving
controlds from the problem form to the new.

 

[Guest]

Setting the properties similar to the old form did not improve things.
Although I was unable to get the Visible property set to true. I attached a
macro to the form so that when it opened the form.visible value would be set
to yes. But in the documenter is still appeared as false.

Anyway, I "solved" the problem by creating a blank form and copying the
controls from the "bad" form. The new form has a vertical scroll bar and
seems to be functioning (after copying the VB module to the new form) as it
should. Guess I should have tried that before posting!

I appreciate your help.
Nicole

 

[Ken Snell [MVP]]

Glad you were able to fix it!

 

[Guest]

Thanks very much to both of you. I was having exactly the same problem. So,
following your example, I created a new form and copied everything over.
Presto! Thanks for saving me hours of work.