I was looking for a simple way to reproduce a web style expandable sidebar (accordian subform, expandable subform, sliding subform, shutter subform, or whatever name you'd like to use to describe it in MS Access), instead of merely making a subform visible/invisible. The attached file, does exactly that and with a single change to a constant variable you can control the speed of the shutter/slidder.
This is a very crude example to illustrate the principle. You can use any subform you like, within any form you'd like. There are no requirements to make this work and all the code is native MS Acces code, no external references, or ActiveX Controls. The button used to expand and retract the subform can also be changed as you see fit, it is just a question of placing the brief code behind whatever button you select to use in your design.
Just another nifty method to add a little wow factor to a form.
Sliding/Shutter Subform Example Download
Current average ratings.



Saturday, June 9th, 2012, 10:00 pm | 


June 11, 2012 at 5:04 am
Nifty and timely. Thanks for all your wonderful posts. I lounge here every other day.
June 11, 2012 at 2:14 pm
I'd been previously looking high and low for a method of doing exactly this in my app, but could never find an example. I was delighted today to come across your site and discover this sample. It is a very nice demonstration and I was quickly able to integrate it into my app. Thank you for sharing.