>Hi Paul,
>
>>I've got a field on one of the reports I'm designing that the report designer seems to like to clip. I've only got a limited amount of space, and I'd like to use all of it (if needed). The report designer is clipping it at the first space.
>
>Yep, the Report Designer is smart enough to display only entire words. *eg*
>
>Left() does work, when you have a non-proportional font. Stretching with overflow, if the text might go into the next line. If both is no option, make the textbox as large as necessary and cover the unwanted part of it with a white shape.
>
>Christof
I originally tried using LEFT, but then realized it was only going to work with a non-proportional font. The problem I'm having is this report is actually a label, and I don't have any room to make the field any larger. I guess it looks like my only option is to switch to a non-proportional font. Either that, or figure out how to calculate how many characters would actually able to fit in that space, then use LEFT. But, for some odd reason, I don't think that's going to happen ;)
-Paul