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.
 

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

Can shrink with sub-report 1
Check Name in a Specific Customer Record - after update 0
Group Header section height will not shrink 3
Can Shrink 4
can grow, can shrink with subreports; suppress with blank lines/ar 2
Create family directory with conditions 1
Gan/Grow Shrink in page header - is it fixed in Access 2007? 8
Can Shrink option not working with Rich Text 0

Top