Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Field Property Strech with overflow 1

Status
Not open for further replies.

SergeantC

Technical User
Sep 11, 2008
9
US
I am working on a report that has a field that can hold up to 80 characters. However, it may hold one half or less.

Assume I have the field width on the report set to 40 characters and the field height set to two lines.

Is there a way to insure the bottom line is filled first and if there is more than 40 characters then the top line is used?

I have a JPG of what it is currently doing, and what I want it to do but can't figure out how to attach it to this thread.

Thanks in advance for any help or suggestions.
 
Try using 2 controls with the print "when" set to the over/under 40 characters in the field so only one of the controls prints based on the character length.

Auguy
Northwest Ohio
 
PostSergeantC,

I agree with Auguy's advice. However, keep in mind that the width of a report object is measured in inches, mm or pixels, not in characters.

Testing for greater than 40 characters in your Print When will only give you an approximate solution. To be sure that it will work properly, you would need to use a monospaced font (which many users might regard as ugly).

You also asked how to display a JPG in the thread. You must first place the image on a web server - it can be anywhere you like, provided you know the URL. You then insert an tag into the thread. The forum's Help will give you more details.

That said, I would urge you strongly NOT to do that. Unless the image is very small, it will cause the entire thread-viewing area to resize to accomodate the width. All the text will also occupy the new width, which means visitors will have to constantly scroll horizontally to read anything. It makes the whole thread a pain to read.

Hope this helps.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

[url=www.ml-consult.co.uk] My Visual FoxPro site: www.ml-consult.co.uk[/url]
 
Auguy,

Thank you for your help it works great I never thought of stacking the fields on top of each other and using Print When.

Thanks again for your time

SergeantC
 
Thanks to Mike for the additional information, I should have included something about the fonts.

Auguy
Northwest Ohio
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top