Shrink Field in a Report

T

TAFNAP

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.
 
R

Rick B

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
 
T

TAFNAP

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...
 
W

weiwei

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;
 
Top