Since RS is building a report based on a dataset from a database... and fields in a database have precise width limits... are there ways to make sure that your text box or whatever can accommodate X characters... other than allowing the text box to wrap... or guessing what size you should make it?

I didn't think so, I thought you had to hard-code the width. Now, you may be able to calculate the width of the characters and dynamically change the textbox width using code, but I'm not sure about that...

Brian

One of the Properties for a textbox (when you right-click on the box and choos Properties) is Textbox Height. Click off the "Can Increase to accommodate height" and then at least the data will get truncated. Try to make the field big enough in to accomodate most data.

It doesn't specifically resolve your issue but it would at least keep it from going to two lines.

have you found any solution to this problem?

MER78 I'm sorry to post out of place here, but I'm assuming you haven't read your old Post in a while. Regarding your post on drill down tables...you reference p130 of a book...what book was that? I'm looking for a good book, and in fact I'm having a problem w/ drill downs that I believe p130 of whatever book you're reading could help.