Shrink Field in a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I appoligze if this has been asked before I searched and couldn't find what I
am looking for. I am trying to format a report to make it more professionial.
What I would like is as follows...

XYZ Company
1 Main Street
City, State Zip

What I am getting is

XYZ Company
1 Main Street
City State Zip

I read up on Shrink but I can't seem to be formating correctly to remove the
empy spaces and contract the two fields so it is formated correctly. Thanks
in advance.
 
You would replace your CITY, STATE and ZIP with an unbound text field. In
that field, put the following...


=[City] + ", " + [State] + " " + [Zip]



Hope that helps.

Rick B
 
Rick B said:
You would replace your CITY, STATE and ZIP with an unbound text field. In
that field, put the following...


=[City] + ", " + [State] + " " + [Zip]



Hope that helps.

Rick B



TAFNAP said:
I appoligze if this has been asked before I searched and couldn't find what I
am looking for. I am trying to format a report to make it more professionial.
What I would like is as follows...

XYZ Company
1 Main Street
City, State Zip

What I am getting is

XYZ Company
1 Main Street
City State Zip

I read up on Shrink but I can't seem to be formating correctly to remove the
empy spaces and contract the two fields so it is formated correctly. Thanks
in advance.
Click to expand...
Click to expand...
 
Thank you I appologize I was looking in the wrong area I saw yur post in the
report section of this forum for another user. So I am trying your fix now.

Rick B said:
You would replace your CITY, STATE and ZIP with an unbound text field. In
that field, put the following...


=[City] + ", " + [State] + " " + [Zip]



Hope that helps.

Rick B



TAFNAP said:
I appoligze if this has been asked before I searched and couldn't find what I
am looking for. I am trying to format a report to make it more professionial.
What I would like is as follows...

XYZ Company
1 Main Street
City, State Zip

What I am getting is

XYZ Company
1 Main Street
City State Zip

I read up on Shrink but I can't seem to be formating correctly to remove the
empy spaces and contract the two fields so it is formated correctly. Thanks
in advance.
Click to expand...
Click to expand...
 
TAFNAP said:
I appoligze if this has been asked before I searched and couldn't find what I
am looking for. I am trying to format a report to make it more professionial.
What I would like is as follows...

XYZ Company
1 Main Street
City, State Zip

What I am getting is

XYZ Company
1 Main Street
City State Zip

I read up on Shrink but I can't seem to be formating correctly to remove the
empy spaces and contract the two fields so it is formated correctly. Thanks
in advance.
Click to expand...


ljlhjljljk;
 
Back
Top