Help with Me.MoveLayout = False

[Guest]

I'm using Me.MoveLayout = False to create a gantt style calendar chart with
data in each box. The issues i'm having is that some of the events are short
and do not have enough room in the box to put in the information i need to
display. If I make the box taller so that the text will wrap, the boxes begin
to overlap with each other. Anyone have any input on this, besides making the
font smaller?

Thanks!!!

 

[Marshall Barton]

I'm using Me.MoveLayout = False to create a gantt style calendar chart with
data in each box. The issues i'm having is that some of the events are short
and do not have enough room in the box to put in the information i need to
display. If I make the box taller so that the text will wrap, the boxes begin
to overlap with each other. Anyone have any input on this, besides making the
font smaller?

Generally, I use a second text box with a transparent back
style. Then if the text fits, set its Left property to the
Left of the colored box. If it won't fit within the width
of the colored box, set the text's box left property to the
right of the colored box.

A somewhat ugly alternative is to always place the text
under the box.

Another idea is to make the text's box as wide as the page
and don't worry about whether it fits into the colored box.