Hello

#1 is a common solution. The memo fields are placed exactly on top of each other so they do not consume any additional space. The fields are activated within the print when area of the field. Based on te evaluation of the print when only the appropriate one is displayed. The number of characters could be used as a rough approximation to do this, but figuring out the true width of the string using txtwidth() will give you a better result especially on variable width fonts. The txtwidth() function can be used to compensate for the size and characteristics of the font (check documentation)

#2 If the report is compiled into the project it is readonly, so it cannot be hacked. You can use 'copy file' to copy the individual files out (using a different base name) or you can 'Use the FRX' file and 'Copy To'. You open your editable version 'use myreport.frx' and then just change the value in the font size column. You can make the default memo field an odd fontsize (EX:5 pts) and 'replace font size with xx for font size=5'. As Naomi pointed out, this method will work for 1 record only without chaining reports.

#3 would take more work, I believe option #1 is the best bet.


>Hi
>I have a problem with all the offers:
>1. I have an few memos in my report and it's full, so It's will not help me more place (BTW How can I change the TxtWidth in the report?).
>2. How do I get&change the frx and how to copy it?
>3. This option is not relevant for one page, How can you change it in multy pages?
>
>
>>Hello Chaim
>>
>>There are a couple ways,
>>
>>Multiple fields overlapping each other using print when to determine the proper one (but instaed of length you may want to use TxtWidth)
>>I have done this, easy to implement, but coarse in sizing
>>
>>Another way is to dynamically hack the frx, prior to the report running determine the max font size that will fit the space, find the record in the FRX and replace the font size column.
>>I have done this also, easy to implement, but report cannot be compiled in (if it is you can make a copy and tweak the copy)
>>
>>Third way, write your string out to a graphic, using VFP or automation, and use the graphic in the report which you can scale. This works well but is harder to implement.
>>
>>Another way, which I havn't tried, is to use Rich Text, maybe someone can chime in on this one.
>>
>>Bob
>>
>>
>>>Hi
>>>I have a report with memo field.
>>>Can I tell VFP to give all the date in one place but the font size will be change by the value len?