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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Line count without a carrige return

Status
Not open for further replies.

purcion

Programmer
Feb 14, 2005
32
AU
Hi,
Is there a way to count the number of lines of text in a field?
I tried using PatternCount with the carrige return symbol as my searchstring and this doesnt work(unless of course you have manually added carrige returns with the enter key) It wont find whats not there.
It seems that when the text comes to the boundary of a field it just gets pushed down to the next line without a carrige return. Is there some way I can get a line count going.? I hope this makes sense .
Thanks ..
 
The number of lines is really dependent on the font size and the font style & family.

You could pobably get a fair estimate of the number of lines if you counted the number of characters in a typical line and divided the total number of characters in the field by that value.

Example:

Length(table::field) / 60

-Striker
 
Thanks for your reply,
Its a pity with fmp that something that should be a standard function has to be dealt with in a work around manner.Your suggestion is good I appreciate that but it wont quite cut it especially if a field has odd paragraphs bulleted lists and so on. I really needed to be able to get hold of the line numbers because of the crummy way it handles printing ,fmp takes almost like screen shots of feilds for print preview.
Anyway thanks for your time
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top