Variable Text Field Format

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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,
 
Back
Top