Access Form Embedded Excel Spreadsheet Does Have Scroll Bars

Michael Vasilevsky
Michael Vasilevsky used Ask the Experts™
on
I'm trying to embed an Excel spreadsheet in a MS Access form to create a schedule display. I'm using an Unbound Object Frame and am having the problem that Excel's scroll bars are not displaying. Is there a way to get scroll bars?
Embedded-Spreadsheet-No-Scollbars.PNG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
Rather than embedding the display into Access,  why not use Application.FollowHyperlink sPathFilename ?
Michael VasilevskySolutions Architect

Author

Commented:
Thanks but I do want to display the data in the Access form, rather than force the user to go some place else. Are scroll bars not an option?
Solutions Architect
Commented:
I used the MS Office Spreadsheet ActiveX control. Details here: https://dikuw.wordpress.com/2016/02/04/scheduling-and-a-calendar-in-ms-access/
Scheduling-DB.accdb
Michael VasilevskySolutions Architect

Author

Commented:
ActiveX spreadsheet control worked

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial