Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / January 2006

Tip: Looking for answers? Try searching our database.

A fairly dense form needs real estate. Don't have it. Want to resize ONE control only

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MLH - 12 Jan 2006 15:50 GMT
Me!AddnlOwnrList.Width = 5.1875
Me.Repaint

Have tried the above in the on got focus event code
to make the listbox control wider when its being used.
I tried it in the Enter and Exit event code too.

My control more or less disappears when the Width
property is set when tabbing into the control and does
not come back when tabbing off the control. I've never
before experienced this behavior when resizing controls.

Would like to know if anyone has experienced similar
behavior.
Tim Marshall - 12 Jan 2006 16:19 GMT
> Me!AddnlOwnrList.Width = 5.1875

Width and indeed, all measurements are measured by twips.

FROM THE ACCESS 97 **** HELP *** FILE:

Put your cursor on the "width" part of your above code and simply press
F1 and you'll get a section on:

Height, Width Properties

Look about halfway down the page, under "Setting" and you'll find:

"In Visual Basic, use a numeric expression to set the value of each
property. Values are expressed in twips."

Since you probably won't look at help anyway or claim you don't have it
or can't get the above, "twips" is linked to something curious which
tells you that what you're missing above is (assuming you're using inches):

Me!AddnlOwnrList.Width = 5.1875 * 1440

Signature

Tim    http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto  "TIM-MAY!!" - Me

fredg - 12 Jan 2006 16:47 GMT
> Me!AddnlOwnrList.Width = 5.1875
> Me.Repaint
[quoted text clipped - 10 lines]
> Would like to know if anyone has experienced similar
> behavior.

Are you trying to set the list box width to 5.1875 inches?
Access property sizes, i.e.  Width, Top, Left, etc. are all measured
in Twips (1440 per inch).
A width of 5.1875 Twips would be so small as to be un-viewable.
Try:

Me!AddnlOwnrList.Width = 5.1875 * 1440.
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

MLH - 12 Jan 2006 17:18 GMT
Again, I was struck by the HITB syndrome.
Thanks a bunch, fredg, for helping me yank
it out once more!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.