Remove gaps between fields.

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

Guest

Hello,
I have made a report in Access 97. It contains first and
last names that are left justified. There are gaps
between these two fields depending upon the size of the
names. I assumed that setting "can grow" and "can shrink"
to yes would resolve this.

Thank you in advance for your help.

Ellen
 
The easiest method is to concatenate the fields like:
=[FirstName] & " " & [LastName]
Make sure the name of the text box is not the name of a field.
 
Can grow only expands vertically. Use '=[FirstName] & " " & [SecondName]' in one text box to create a single name string
 
Yes it works. Thank you, Duane!
-----Original Message-----
The easiest method is to concatenate the fields like:
=[FirstName] & " " & [LastName]
Make sure the name of the text box is not the name of a field.

--
Duane Hookom
MS Access MVP


Hello,
I have made a report in Access 97. It contains first and
last names that are left justified. There are gaps
between these two fields depending upon the size of the
names. I assumed that setting "can grow" and "can shrink"
to yes would resolve this.

Thank you in advance for your help.

Ellen
Click to expand...


.
Click to expand...
 
Thank you, Jeremy!
-----Original Message-----
Can grow only expands vertically. Use '=[FirstName] & " "
Click to expand...
& [SecondName]' in one text box to create a single name
string.
 
Back
Top