How to get variable length memo field
Hi,
I've got a field represented in Nexusdb as a shortstring, which I use as
a comments field.
I'm trying to print thses comments in a report region.
I use a region beacuse I fin it's the best way to otpionally show a
group of fields.
The region contains 2 fields only, a pplabel 'comments' and a ppdbmemo
field which is directly linked to the shortstring database field.
How do I gte the region (and the comments field) to expand and contract
so that I don't waste space between records when ther is only one
line(or no lines) to be printed in the dbmemo field.
Cheers
Tony
I've got a field represented in Nexusdb as a shortstring, which I use as
a comments field.
I'm trying to print thses comments in a report region.
I use a region beacuse I fin it's the best way to otpionally show a
group of fields.
The region contains 2 fields only, a pplabel 'comments' and a ppdbmemo
field which is directly linked to the shortstring database field.
How do I gte the region (and the comments field) to expand and contract
so that I don't waste space between records when ther is only one
line(or no lines) to be printed in the dbmemo field.
Cheers
Tony
This discussion has been closed.
Comments
1. Be sure the DBMemo is in fact inside the region. Use the report tree to
be certain.
2. Set the Stretch property of the region and the memo to True.
3. Set the PrintHeight property of the band you are using to phDynamic.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Finally got around to trying it and it works fine. Thank you. I now have
another related problem relating to switching the display of the region
on and off.
In order not to display the region at all I set the visible property to
false. This successfully suppresses display of the pplabel field, but
not the dbmemo filed. It still displays. I have double checked that the
dbmemo filed is in fact inside the region by reference to the report
tree as per your suggestion.
Regards
Tony
it--and I use regions & sub reports in this fasion quite a bit.
Ed Dressel
Team DM
in the dbmemo and the dbmemo field no longer shows
Hi Ed,
See my subsequent post where I took off the shiftrelativeto field. It
was set to the region in which it lived. Just put it back in and the
problem reappeared..repeatable.
Tony