Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing Memo always has extra line
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01473506
Message ID:
01473540
Views:
39
? asc(RIGHT(alltrim(CurCmts.casecmts),1)) show 42
Here is what is in the memo.
***DIABETIC***
TO TOMAS/NELSON/ESTELLA/KARLA
MEDICARE PART B ID# 12345678A  /  BCBS ID# 500730 123456


**ESTELLA - PLEASE CHECK CARD PULLED FOR THIS PROCEDURE**
42
>>Using VFP8SP1
>>
>>One of the fields in a report is a memo fields (returned from a text field in SQL Server). The field has about 1/3 of the report space allocated to it on the report and is set to stretch. Basically it works correctly it works correctly with the exception that there is always an extra line under the last of the text when it prints. Field field value in the report is:
>>
>>
ALLTRIM(RptData.CaseComments)
>>
>>I have checked for CR & LineFeeds at the end, but there aren't any. I was wondering if anyone else has encountered this or if anyone has some suggestions.
>>
>>Thanks
>
>What ascii(RIGHT(alltrim(...),1) returns?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform