conditional format truncates memo field

O

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
 
J

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
'====================================================
 

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

Similar Threads

text box in report is truncating memo field at 255 characters 2
Memo Field is truncating to 255 Chars 6
Access Report with Sub-Report & memo field ??? 4
Memo field truncated in query/report? 1
Records disappearing in report with Conditional Formatting 3
Conditional Formating 2
Export truncates memo field 2
Memo Field Truncating in Word 3

Top