Re: Wordwrap

"Henning" <computer_hero@xxxxxxxxxxxx>'s wild thoughts were
released on Tue, 25 Apr 2006 01:05:30 +0200 bearing the
following fruit:

From Help

Is this valid for bound too?

If the text in a cell is too long to display in the cell, and the WordWrap
property is set to True, the text wraps to the next line within the same
cell. To display the wrapped text, you may need to increase the cell's
column width (ColWidth property) or row height (RowHeight property).

Yes but it's the setting of the height that is the OP's
problem.

J

/Henning

<JoeGrownup@xxxxxxxxxxxxxx> skrev i meddelandet
news:14op42tdra5dm9uv2jkijl00m5540qb5l1@xxxxxxxxxx
On Mon, 24 Apr 2006 14:56:52 +0100, Jan Hyde
<StellaDrinker@xxxxxxxxxxxxxxxxxxx> wrote:

JoeGrownup@xxxxxxxxxxxxxx's wild thoughts were released on
Mon, 24 Apr 2006 08:27:31 -0500 bearing the following fruit:

I have a VB6 app which uses M$ Jet, ADO, and MSHFlexgrid. The DB has
two fields with about 60 string characters. I want to wordwrap the
flexgrid. Have to use the hidden textbox to adjust the row height on
the flexgrid. That is not a big deal. The problem is where do I put
the code for the height adjustment? I just looked through the Events
of the MSHFlexgrid and the ADO, and I see no real place for the code.
I want the flexgrid row height to be adjusted automatically when the
data comes off the database.

Any ideas?

The same place your using 'the hidden textbox'?

I'm guessing your binding the control to some datasource? If
so then that's part of the problem with databinding, it does
it 'all' for you, taking the control away from you.

The ADO is bound to the Jet DB and I have the flexgrid bound to the
ADO. I see no way to adjust the row height of the flexgrid
automatically as the data is being loaded from the DB. Got any ideas?



Jan Hyde (VB MVP)

--
Rich foods are like destiny. They, too, shape our ends. (Art. Moger)

.

Relevant Pages

  • Re: Wordwrap
    ... If the text in a cell is too long to display in the cell, and the WordWrap ... Have to use the hidden textbox to adjust the row height on ... the flexgrid. ...
    (comp.lang.basic.visual.misc)
  • Re: Keep cell size
    ... Excel turned on wordwrap when I did this. ... And if you have wordwrap already toggled on, ... then plop your data in and then adjust the rowheight back to what it was. ... And the only way I know that you can stop excel from filling the adjacent cell ...
    (microsoft.public.excel.misc)
  • Re: countif multiple conditions
    ... if your sheet names or cell locations are different, ... location they don't adjust. ... John word ... Ann excel ...
    (microsoft.public.excel.worksheet.functions)
  • Passing data from a dll to the main VB program
    ... was written it sets up a FlexGrid where the columns are time intervals and ... click on a grid to a cell on or off. ... A new dll was written specific to the control hardware. ... FlexGrid. ...
    (microsoft.public.vb.general.discussion)
  • Re: Auto Row Height in Merged Cells with pre exisiting text
    ... The cell range is A50:AA142 ... Dim CurrentRowHeight As Single, MergedCellRgWidth As Single ... This says to not adjust the rowheight if the current row height is larger than ...
    (microsoft.public.excel.programming)
Loading