Solved

resize browser in vba

Posted on 2004-09-13
5
402 Views
Last Modified: 2010-05-18
Hello Experts. I don't know if this is the right question to ask, but it's the only way I can think to resize a form, that contains a browser, to the Height & Width of that browser upon loading. You see, there's this additional width of about 3/4 inch that I can't seem to get rid of on the right hand side of the browser. Real pain in the neck. So, if any of you Experts out there know how I can do this in VBA, please tell me.
Many kind thanks in advance,
John
0
Comment
Question by:John Account
  • 3
  • 2
5 Comments
 

Author Comment

by:John Account
ID: 12050292
Ooops...Typo. Title of the Question was meant to read: Resize Form to Browser in VBA.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12050338
Do you mean you can't get rid of the 3/4 in design view or when in form view?
0
 

Author Comment

by:John Account
ID: 12050420
in form view.
0
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 200 total points
ID: 12050441
Set the form's Autoresize property to "No". Now open the form in form view and size the form how you need it to be. Press CTRL+S (or click File->Save) to save it. Once you reopen the form, it *should* have kept the same size as when you saved it.
0
 

Author Comment

by:John Account
ID: 12050460
You're the best, shanesuebsahakarn. Thanks!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
view mode vs edit mode 17 47
vba DCount with 2 criteria 3 33
Track name AutoCorrect info 14 46
Format a Field AFTER UPDATE 5 18
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now