Odd problem with Memo field and bold font

C

Carl Rapson

I have a report containing a memo field. I need to bold certain records in
the report, which I handle in the Detail_Print event by setting each field's
FontBold property. For certain records, this results in the last line of the
Memo field being "cut off" somehow. This only occurs on bolded detail lines.
After looking through the newsgroup, I've checked all of the following
possibilities:

1. The underlying Query contains no GROUP BY or DISTINCT
2. The Memo field is not included in the report Sort/Group dialog
3. There is nothing in the Format property of the Memo field in the report
or in the underlying data table
4. The Can Grow property is set to Yes for the report field and the report
Detail section
5. If I run the underlying Query directly, all of the Memo field text show
up

As I mentioned, this only seems to occur when I bold the font, and only for
certain records (it is consistent). Also, it doesn't seem to be a function
of the Memo field length, as I've had it occur on relatively short Memo
fields as well as longer ones. But other Memo fields display completely even
when bolded. None of the Memo fields currently contain more than 255
characters.

Does anyone have any ideas as to why this might be occurring, or what else I
can look for?

Thanks for any assistance,

Carl Rapson
 
M

Marshall Barton

Carl said:
I have a report containing a memo field. I need to bold certain records in
the report, which I handle in the Detail_Print event by setting each field's
FontBold property. For certain records, this results in the last line of the
Memo field being "cut off" somehow. This only occurs on bolded detail lines.
After looking through the newsgroup, I've checked all of the following
possibilities:

1. The underlying Query contains no GROUP BY or DISTINCT
2. The Memo field is not included in the report Sort/Group dialog
3. There is nothing in the Format property of the Memo field in the report
or in the underlying data table
4. The Can Grow property is set to Yes for the report field and the report
Detail section
5. If I run the underlying Query directly, all of the Memo field text show
up

As I mentioned, this only seems to occur when I bold the font, and only for
certain records (it is consistent). Also, it doesn't seem to be a function
of the Memo field length, as I've had it occur on relatively short Memo
fields as well as longer ones. But other Memo fields display completely even
when bolded. None of the Memo fields currently contain more than 255
characters.

Does anyone have any ideas as to why this might be occurring, or what else I
can look for?


You say you're setting the bold property in the setion's
Print event, right? If so, that's too late, the CanGrow
height of the text box is determined before the Print event
occurs. Try using the section's Format event instead.
 
C

Carl Rapson

Marshall Barton said:
You say you're setting the bold property in the setion's
Print event, right? If so, that's too late, the CanGrow
height of the text box is determined before the Print event
occurs. Try using the section's Format event instead.

Thanks, Marshall, that solved it. I swear, reports are going to be the death
of me yet.

Carl Rapson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top