Variable Text Field Format

G

Guest

I am printing reports and want to eliminate the blank
space at the end of fields. For example a "first name"
field may be 30 characters long. How can I pring the last
name immediately after the first name without all the
unused blank spaces showing in the report?
 
C

Cheryl Fischer

Replace the two textboxes used for FirstName and LastName with a single
textbox named txtFullName. Make the Control Source of that textbox:

= Trim(FirstName) & " " & Trim(LastName)

hth,
 
Top