As I pointed out in my previous message, when you use method 2, the field that covers the dots must be OPAQUE.
HALinNY => -----Original Message----- => From: [EMAIL PROTECTED] => [mailto:[EMAIL PROTECTED] On Behalf Of James E. Harvey => Sent: Tuesday, August 22, 2006 08:58 => To: 'ProFox Email List' => Subject: RE: Append ellipsis (tab leader dots) in report column => => Below is the text from MSDN web site: => => "Add the dot leaders by creating an object with an => expression of REPLICATE('. ', 50). The 50 should be adjusted => to fit the width and font of the report. Make sure the dot => leaders object is Sent to Back, so it prints behind the code => and description." => => Sounds easy. => => I added a field to the designer form the Report Control Toolbar. => Inserted this in the Expression field "REPLICATE('. ', 30)" => Selected the "Field", "Format", "Send To Back". => => I overlay the "Column" field on top of the "Replicate" field => in the detail band on the designer. => => Run the report and the "dots" still show up "behind" the => "Column field data => => I must be missing something? => => => => => => => => => => => James E. Harvey => Corresponding Officer/M.I.S. => Hanover Shoe Farms, Inc. => www.hanoverpa.com =>[EMAIL PROTECTED] => 717-637-8931 => fax: 717-637-6766 => => -----Original Message----- => From: [EMAIL PROTECTED] => [mailto:[EMAIL PROTECTED] On Behalf Of Ted Roche => Sent: Monday, August 21, 2006 4:02 PM => To: [email protected] => Subject: Re: Append ellipsis in report column => => On 8/21/06, James E. Harvey <[EMAIL PROTECTED]> wrote: => > I meant tab leader dots, not "ellipsis", sorry. => > => => Not easy, since you run into foxel issues, but you want to => do something => like: => => replicate(".", LengthOfBox - textlength(yourtext)) + yourText => => Where LengthOfBox and textlength need to be calculated based => on the specific font and font size. => => Googling "leader dots FoxPro report" yields: => => http://msdn.microsoft.com/library/en-us/dnfoxgen9/html/VFP9Re ports2.asp?fram => e=true => => if you're in VFP 9 and => => http://www.hentzenwerke.com/catalog/vfprwfaq.htm => => if you're not. => => -- => => Ted "The Answers Are Out There" Roche => Ted Roche & Associates, LLC => http://www.tedroche.com => => [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

