Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo Field
Message
From
21/06/2001 03:16:26
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
20/06/2001 15:00:09
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00521622
Message ID:
00521773
Views:
14
>I have a report that uses a couple of memo fields. If the memo field is larger than three lines(dictated by carrage return) I loose all objects below this field. I either need a way to make the report field size dynamicly or strip all carrage returs out of the memo field before it gets to the report writer.

Steven,
Strech and float checking would take care of long memos. If you mean multiple CR within the memo + trailing CRs are a problem :
lcMemo = chrtran(myMemo,chr(13)+chr(10),chr(10)) && CRLF to LF
do while occurs(chr(10)+chr(10),lcMemo)>0 && While multipl LF exists
  lcMemo = strtran(lcMemo,chr(10)+chr(10),chr(10)) && Half the LFs
enddo
lcMemo = left(lcMemo,len(lcMemo)-iif(right(lcMemo,1)=chr(10),1,0))
This would reduce multiple consequtive CRLF to one. You could have this code slightly modified in either lostfocus of editbox (so would do it as editing done) or as a UDF just to call from a report (not a problem IMHO since in reports real botleneck is printer which is slower than fox code). And since code uses halving system which means with say 1024 CRs loop would take 10 passes I don't think you'd need faster routines like C FLLs.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform