Growing and Shrinking a field in a report/letter

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I am creating letters to be sent out to our customers. I
have a sentence where some of the parts stay the same
while the others change based on the product. To
oversimplify things, I have a sentence that reads
something like the following:

Thank you for ordering XXXXXX. We appreciate your
business.

The "Thank you for ordering" and "We appreciate your
business" are simply labels that never change. XXXXXX
may be six or seven characters up to about 15 and is a
field that I am inserting into the sentece. I have set
the spacing so that the values in XXXXX that are 15
characters are spaced right to flow into "We appreciate
your business". However, this looks bad for the products
that are only 6-7. There is a huge space between the end
of these product names and the "We appreciate your
business". Is there are setting that will perfectly
align XXXXXX with the "We appreciate..." regardless of
it's length? I tried working with the Can Grow and Can
Shrink but could not get it to work right.

Thanks,

Chuck
 
Chuck,

The way I like to do this is to use one textbox and
concantenate the information together in it. Create a new
textbox, not a label, and put in the following for it's
control source.

="Thank you for ordering " & [YourProductField] & ". We
appreciate your business."


--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top