Re: HOW TO SHRINK OR GROW COMBO BOX

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thank you very much for your tips, Dale. I am sure they will come handy.

However, what I am looking for right now is a way to make the data of the
combo box PRINT (on paper) in its entirety. As it is, when my combo box is 1
inch wide, and the data is more than 1 inch long, the data is truncated when
I print the form.

However, the Can Grow property of the textbox makes its data print in its
entirety by "growing" it downwards, even when the box is only 1inch wide when
the data is 3inch long.

I sincerely hope I am making sense.
--
Glint


"Dale Fye" wrote:

Even with your explaination, I'm still not sure I'm on your wavelength about
this, but I'll give it a shot.

You could set the width of various columns in your combo box, to a total
width of 6 or 8 inches, but only show the combo box as 2" wide on the form.
If you are going to do this, make sure that the column that is 2 inches wide
is the first non-zero width column you want to display in the combo box.

Then, in the GotFocus event of the combo, change the width of the combo box
to the width you need to display all of the columns. Then, in the Click,
AfterUpdate and LostFocus events, change the width back to the original 2".
I occassionally use this technique when I want to display a short text
string, when viewing the record, but when editing or adding a record, want to
see more of the detail of the record behind the combo box.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"Glint" wrote:

Thanks Jeff.
Actually, I want to see how I can save space by making the combo box narrow,
thereby forcing the data into a narrow column instead of a long line.
--
Glint


"Jeff Boyce" wrote:

Glint

We may be talking about different objects. The combobox in an Access form
is only one "line" tall. Why would you need to have it "Grow"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Glint" <Glint@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:41258894-B896-41AA-B4D0-654D09016AF3@xxxxxxxxxxxxxxxx
Hi Guys,
I have a form with several comboboxes and textboxes. I find the Can Shrink
and Can Grow properties of the textboxes very handy, especially when thier
data is nil or exceed the space I have provided when I print the form. Is
there a way I can make the combo boxes behave the same way?
--
Glint



.

Relevant Pages

  • Re: Handys werden immer gefaehrlicher
    ... was bitte ist IMSI-Catcher? ... Display und eigentlich staendig ausgeschaltet, ... dass mein Handy nicht im Schlafzimmer liegt:) ... jedoch merke, auch *Ohropax* haetet wohl nicht verhindert, dass am ...
    (de.talk.tagesgeschehen)
  • Re: Funktioniert sync mit iSync und 9300i perfekt?
    ... Series 5 und den NC9210i. ... gibt es BT und damit stört mein Handy in der Tasche nicht wirklich. ... ausziehbare Display riesig, der 9300i hat durch das breite Querformat ...
    (de.comp.sys.mac.misc)
  • Re: GPS-Logger
    ... USB-Schnittstelle und kleines ggf. ... Display wären nicht schlecht. ... bezeichnet wurde habe ich bei EBAY erstanden. ... Handy oder PDA. ...
    (de.rec.outdoors)
  • Re: Pollin Display und SED1560
    ... Ich habe hach einem Handy gesucht, ... Display mit den Sondersymbolen gleich aus. ... Prev by Date: ... Next by Date: ...
    (de.sci.electronics)
  • Re: Why did both my scroll bars disappear in MS Project 2007?
    ... I figured you might pick this up, Dale. ... I searched through Help thinking ... Select the Scroll Bars option in the Show ... timeline extends much further to the right than the screen can display. ...
    (microsoft.public.project)