auto width on report fields?

  • Thread starter Thread starter teasdam
  • Start date Start date
T

teasdam

I'm trying to make a report of plant names with genus and species. Som
of the genus names are much longer than others though, so I've bee
setting the field wide enough for the longest name, but then plant
with shorter names are spaced to far apart.

example...

_Genus____________________Species_
Lygodesmia (Stephanomeria) juncea
Avena fatua

...so the long name looks good, but the short one ends up with a lot o
white space before the species field. I played with the "can grow" an
"can shrink" format options, but that just expanded the field heigh
instead of width. Any ideas
 
Does it work to concatenate the values like:
="The patient's first name is " & [FirstName] & " and last name is " &
[LastName] & "."
 
I'm not completely sure what you're telling me to do, but this is what
tried...

In design view, I right-clicked on the "genus" text box where data fro
the genus field is displayed. Under Data -> Control Source, I clicke
on a "..." button and found the Expression Builder. I entered the
signs like you showed in your reply. When I tried to view the report i
asked me to "Enter Parameter Value", and whatever I type in there i
what the genus field displays.

is that what you wanted me to try
 
I'm not completely sure what you're telling me to do, but this is what
tried...

In design view, I right-clicked on the "genus" text box where data fro
the genus field is displayed. Under Data -> Control Source, I clicke
on a "..." button and found the Expression Builder. I entered the
signs like you showed in your reply. When I tried to view the report i
asked me to "Enter Parameter Value", and whatever I type in there i
what the genus field displays.

is that what you wanted me to try
 
This all depends on what fields and constant values you want to display.
Your sample in your OP wasn't clear on this. Whatever you enter in the
control source, make sure the name of the control is not also the name of a
field.

If you can't figure this out, come back with your field names and how you
want them "embedded" in your sentence/string.
 
The way this line is setup is like this...

First is a label box that says "Scientific Name", under the propertie
box it's actually called "Genus_label".

Next is a text box called "Genus" with the control source "Genus"

After that is a text box called "Species_label" with control source a
"Species"

I guess all I really want is to automatically adjust the width of th
Genus field to fit the data, there's nothing affter species so tha
doesn't matter muc
 
You could try a single text box with a control source of:
="Scientific Name " & [Genus] & " " & [Species]
Make sure the name of the text box is not the name of a field.
 
Back
Top