Weird problem with "Can Shrink"

[Jonathan Blitz]

I have a field set to "Can Shrink" on a report.

The control source is set to
=IIf([ActivityType]="Notes",Null,[CustomerName])

In the report the contents of the field are truncated.

It works ok if the field is not set to "can shrink" or if the value is
directly from a control source. Only the combination seems to cause
problems.

Any ideas out there?


--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."

 

[Larry Linson]

I'm not sure that it is "weird" -- it may just be how Access 'views' a
calculated Control. I suspect you can avoid the problem by doing the
calculation in your query to create a calculated _Field_ and using that
_Field_ as the ControlSource. The report won't know, nor care, that the
Field value is the result of a calculation.

Larry Linson
Microsoft Access MVP