conditional format truncates memo field

[owp^3]

i have a report
with a memo field
it truncates at 255 characters

based on a review of other posts
i tested my hypothesis that the conditional formats caused the behavior
the behavior stopped when i removed the conditional formats

unfortunately these formats are integral to the report
if a condition exists for a record then every field displayed for that
record must be bold.

is there some sort of workaround so i can retain the conditional format and
not truncate the memo field?

owp^3

 

[John Spencer]

It appears that you may need to use some vba in the format event of the
section in place of the conditional formatting for this control that
contains the memo field data.


Something like the following.

If SomeCondition = True then
Me.MemoControl.FontBold = True
Else
Me.MemoControl.FontBold = False
End if



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================