Moving vertical scroll bar to left side

[mayestom]

I have a subform that’s in datasheet view, is there a way to align the vertical scroll bar to the left side?

Using:
Win 7
Access 2010

 

[vbaInet]

I've not needed to do this but you should be able to change its position through a couple of APIs.

I would have said you could look into using the Scroll Bar ActiveX control but where you will have problems is when you have Form Header/Footer because the control only spans the section it's in. Plus the fact that you have to code different events just get it going.

 

[mayestom]

vbaInet thank you for your reply.
I'm not sure what this means (which sounds like the less complicated way to go):

you should be able to change its position through a couple of APIs.

fyi: I'm not to versed in coding if that's what API involves.

 

[vbaInet]

API means Application Programming Interface. These are functions that aren't native to Access VBA but are global to Windows as a whole so we're talking advanced stuff.

It's not straightforward either and lots of research is required.

 

[mayestom]

Oh, Okay. Way above my head then.
Just curious: When I open the subform in datasheet view in the property sheet under the Format tab there is a property named "Scroll Bar Align". It's set to System but there are options for Left or Right. But when ever I select Left or right it does not let me select either, it goes back to System. Even when I type it in when I leave the field it reverts back to System.

 

[vbaInet]

I think that's for List box and Combo box controls.

I'm just looking at a Navigation form now. It might be possible.

 

[mayestom]

Oh, was I looking at the wrong Property field or do you think it might work?

 

[vbaInet]

No joy I'm afraid. It's only for text boxes, list boxes, combo boxes and the navigation control. Nothing for a form object.

 

[mayestom]

Okay, well thank you for your time I appreciate it.