Auto size text

[daltman1967]

I have a control on a report that is a fixed width, due to the page size. I want to automatically size the text to fit within the control named 'AName1' (which is a label) so that ALL of it is visible. Centering horizontally is easy, but I'd also like the text to be centered vertically.

Now, I already tried a "if len(d)=10 then AName1.FontSize = 28" type of structure, but a) it's clunky b) it doesn't work every time. Any ideas?

[June7]

Don't know any way to do that. Also, there is no vertical center parameter. Must set the TopMargin property to adjust vertical position. The textbox CanGrow property is intended to handle data of unknown length. The data will wrap to multiple lines. I presume you are trying to avoid this. I have encountered this issue before and had to accept the multi-line.

[daltman1967]

I centered the control when I made it, so that took care of horizontal. I know the "Can Grow," but I HAVE TO avoid the multi line. As far as the top margin, since I don't know what it SHOULD be, how could I possibly set it? I'm sure it would have something to do with the text height.

What I'd like to do, if possible, is to measure the text height & width.

If the width is greater than the box, shrink it. Then, based on the height, I can set the top margin.

[June7]

Sorry, I meant there is no VERTICAL center property. What you are attempting is outside my experience. I wouldn't even try to program this. Calculating text width would not be practical with proportional fonts. Which is probably why you have inconsistent results with present code. I have accepted the CanGrow or arranged record fields to display on more than one line. Also, I have set textbox to non-proportional font (like Courier) then set box width to fit the maximum characters allowed for that field at the font size setting.

[daltman1967]

For me, it is impossible to have data on more than one line. As far as Courier goes, I'm leaving that as a last resort.

I'm printing a 2/3" x 3 7/16" label, single line. The program that comes with the labeler automatically fits the font to the label; it MAY be possible for me to access it through ODBC programatically; if so, then I'll let IT solve the problem of autosizing the text (which it does perfectly). However, I've been printing the label directly through access, which is why I was asking the question.