I have a label in a report and on the opening i change the title of my 
label. The problem is that sometimes the text is too big for the label 
width. I would want to reduce the FontSize of the label if the text is not 
fitting in the Label ??
Someone as any idea ??

<< I have a label in a report and on the opening i change the title of my 
label. The problem is that sometimes the text is too big for the label 
width. I would want to reduce the FontSize of the label if the text is not 
fitting in the Label ?? >>

Whenever I have a conditional label in a report or form, I do one of two 
things:

1) I either put the label alone on one line (e.g. a title) and stretch the 
label size to be the length of the page (left or center justify).  In that 
way, whatever ends up there should fit (as long as I keep the label text 
relatively short).

2) If I have a set of "standard" label captions, say for a textbox, I size 
the label ahead of time so that the longest one fits.  Then whatever the 
label caption is, the text will fit.

Greg