By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

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

P: n/a
MLH
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.
Jan 12 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Thu, 12 Jan 2006 10:50:58 -0500, MLH wrote:
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.

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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Jan 12 '06 #2

P: n/a
MLH wrote:
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

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

P: n/a
MLH
Again, I was struck by the HITB syndrome.
Thanks a bunch, fredg, for helping me yank
it out once more!
Jan 12 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.