hacking my .frx file (stop fields from stretching downwards) 1

[BlackDice]

I've made a dynamic report that is used by adding records to the .frx file as a table at run-time. It's working right (well, mostly anyway), execept that the fields are stretching when they shouldn't be. there's a 'stretch' field in the .frx table that I set to .f., but it stretches anyway. If the field textbox isn't wide enough to display all the text, I want it cut off. Does anyone out there have any experience with this?

BlackDice

http://www.stillwaterexpress.com

 

[craigsboyd]

It should work. I'm assuming that you are also making sure that the other fields have required data such as Top = .T., Bottom = .F., etc.?

I'm not sure how you got to where you are now, but I would think that creating a simple frx with just one field on it that behaves exactly as you want, then opening that frx as a table and looking across at the field values when compared to your dynamically created frx record that is misbehaving would make finding the errant field(s) easier.

SweetPotato Software Website
My Blog

 

[BlackDice]

yeah, I tried that. I put one field with 'stretch' set to .T. and the other just like it was. I looked at both records in the .frx file and the only difference was the 'stretch' field in the .frx. Maybe I missed something so I'll go back and look at it again tomorrow. I hear the horn blowing signalling the end of my work day, so I'm getting outta here. thanks

BlackDice

http://www.stillwaterexpress.com

 

[Nifrabar]

In addition:
I created a .frx from scratch by code and I set the stretch-poperty and that failed......
Using VFP8.
Mike Lewis once called this a weird problem....
-Bart

 

[BlackDice]

Sorry, all. I found out what the problem is. I was SO stupid for this that I feel ashamed to even tell you what it was. But I will anyway, since I wasted everyone's time.

The problem wasn't that the field was stretching at all. The problem was that the height field I put into the .frx was large enough to allow 2 lines of text. Once I cut the height value in half, it works just fine. Many apologies to everyone and I hope I'm not banned from the forums for such a stupid mistake

BlackDice

http://www.stillwaterexpress.com

 

[craigsboyd]

BlackDice,

Not at all, we all do that sort of thing from time to time. I remember running a report over and over again wondering why my changes weren't showing up... even copied everything over to a new report because I thought the other one was corrupted. It finally dawns on me that I'm not running the same copy of the report I'm modifying. It doesn't make you stupid, just human.

SweetPotato Software Website
My Blog