View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default Carriage return character shows in combobox

Increasing the width will allow you to read more of what you put on one
line. You cannot have a second line in a combobox display window where the
user makes input or the selection is shown. I do not know what you are
trying to do, but perhaps you should think about using a textbox or a label
to do it, if you must have a second line. You can always use code to write
messages for user interface. There is always an alternative method to
accomplish the end product.


"SteveZmyname" wrote in message
...
Not trying to be a wiseguy here just trying to understand.

So if I can increase the width but only one line can show at a time will
it
just make that one line wider? Or, by increasing the width I can fit a
second
line in?

Steve

"JLGWhiz" wrote:

Hi Rick, I will paraphrase you.

Trying to put more than one line in a combobox display window will not
work.

You can increase the width.



"Rick Rothstein" wrote in message
...
I may not have been clear in the way I stated my post... I wasn't asking
you to confirm if that is what happened, I was telling you that the
ComboBox cannot show multiple lines of text the way I think you want it
to... to the best of my knowledge, the control simply doesn't work that
way.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in
message
...
That's correct. I can't put in text then do an alt+enter. It just
beeps
at
me. And if I type enough text to go past the width of the combobox it
just
keeps goes out of sight.

"Rick Rothstein" wrote:

If I understand your question correctly... the edit field of the
ComboBox
does not support multiple lines of text.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in
message
...
Hello
I'm using an Active-x combobox with about 8 selection
possibilities. I
need
to make it in a thin column so I'm trying to use two lines when a
selection
is made. Unfortunately it's coming up with the carriage return
character
in
the selection. I guess that's what it is a backwards P sort of
thing.

Looking through the properties for the control I didn't see any
reference
toward word wrap or multiline. In the text field of the properties
it
has
little rectangle boxes that I can't delete.

Any way to make this ugly backwards P go away?
I tried a few things such as...

sub combobox1_Click()
char(10)
End Sub

.




.