Conditional Formatting stops text wrapping

  • Thread starter Thread starter Andrew Proctor
  • Start date Start date
A

Andrew Proctor

A field on my report has a control source which is a memo field. As
such, I have set the "Can Grow" property of this field to Yes.

If I leave it as that, the data in the field wraps as expected.
However, if I try and apply conditional formatting, the field will
format, but not wrap.

It appears that I cannot have both my wrap and format it, so to speak.

Does anyone have any experience with working around this?

Thanks
Andrew
 
CF is not required for reports. Simply pperform the desired formatting
in the Format event of the relevant report's Section.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Thanks for that Stephen, however I am having some difficulty getting
what I want (hence why I was using conditional formatting).
The report in question is a subreport, and contains only the memo field
and the child field (ID). I want to format the text if the first
character in the memo field is an asterisk (Chr(42)), thus my condition
is Left([DESCRIPTION], 1) = Chr(42).

However when adding this condition to the format property of the design
section of the report, all the description fields are formatted if any
one of them evaluates the expression to true.

CF allowed me a simple way of only formatting those records where the
condition was true - and I am always looking for less work :) Is the
only way around this to run some tedious loop evaluating each record in
turn? What it looks as if I need is a format property for the text box
in question, which CF seems to give me...
 
Back
Top