Set Web Control Scroll Bar Value - Code / Macro

[RedVicar]

I have a Web Browser Control which displays the location of premise from a table using Bing. The Control itself isn't large enough to show the entire Bing page, so it has vertical and horizontal scroll bars. It's vertical position is fine, but I'd like it to by default display from the far right hand side as opposed to the left. I'm guessing there's a way to set the ScrollValue (or similar) of the horizontal bar in code, but am unsure what to do. Or perhaps there's a really simple way and I'm missing it. I've done quite a bit of searching, but keep coming up for solutions for List / Combo boxes etc. Any help greatly appreciated. Cheers Red

[ItsMe]

...far right hand side as opposed to the left...

Display what, exactly? Display the scroll bar? Display the map center? If you are talking about the map center, you will probably need to pass lat and lon coordinates as a parameter for Map Center.

[RedVicar]

Nope, forcing the scrollbar far right. The map functionality is fine, but there is a large white box displaying on the left hand side (part of Bing's site, much like Google Maps). Currently a user would need to scroll the horizontal scroll bar right to see the whole map as this white box can't be closed; I'd like to have it scrolled right by default so they don't have to. I would love to tell them to toughen up and scroll it themselves, but sadly they will be using this function many 100s of times throughout the day.

The control source of the Web Control is:

="http://www.bing.com/maps/default.aspx?setmkt=en-CA&where1=" & [txtSuburb] & "&lvl=15&w=100%"

where 'txtSuburb' refers to a Text Box on the main form.

[ItsMe]

I would probably just have the map open in a browser window. You might be able to change the width to 70% or something to get it to fit in the control.
w=70%

[RedVicar]

The users would find it very frustrating opening in a browser - some of the more experienced ones go through 20 - 30 records a minute. They'd probably riot!

I've tried various ways of changing the zoom etc of the control, but the map just re-sizes itself. Forcing the scrollbar right (or setting it to display right-to-left, as you can with text for languages like Arabic) is the only way I can think of atm.

Cheers

R