shrink and enlarge (not grow)

  • Thread starter Thread starter Jakester
  • Start date Start date
J

Jakester

I am trying to create a report that the verbage will remain the same but
names in the report can change which therefore the length of the "name" box
will end up being different length. this will end up having to move the bulk
of the rest of the sentence to the left or right. For example
On 06 Feburary 2009, Joe had a urinalysis test coducted and returned
positive for alcohol with a level of 0.12.
in the example above, the date, name, alcohol and 0.12 are all variables
that are subject to change lengths based of the database information.
I tried canshrink and cangrow but it is not the answer that I am looking for.
 
I am trying to create a report that the verbage will remain the same but
names in the report can change which therefore the length of the "name" box
will end up being different length. this will end up having to move the bulk
of the rest of the sentence to the left or right. For example
On 06 Feburary 2009, Joe had a urinalysis test coducted and returned
positive for alcohol with a level of 0.12.
in the example above, the date, name, alcohol and 0.12 are all variables
that are subject to change lengths based of the database information.
I tried canshrink and cangrow but it is not the answer that I am looking for.
Click to expand...

use an unbound text control on the report.
="On " & Format([DateField],"dd mmmm yyyy") & ", " & [PatientName] & "
had a urinalysis test conducted and returned positive for alcohol with
a level of " & [AlcoholLevel] & "."

Change the control names as needed.
 
Back
Top