Can Shrink where data is spaces

M

mscertified

How can I make 'can shrink' work when the data contains spaces? I have no
control over the data since it comes from a mainframe system. I tried the
following but it gave me #Error

=IIf(Trim([Str2])='',Null,[str2])
 
M

Marshall Barton

mscertified said:
How can I make 'can shrink' work when the data contains spaces? I have no
control over the data since it comes from a mainframe system. I tried the
following but it gave me #Error

=IIf(Trim([Str2])='',Null,[str2])
Click to expand...


=Trim(str2) should be sufficient.
 
Top