text box with multiple controls?

  • Thread starter Thread starter Carma via AccessMonster.com
  • Start date Start date
C

Carma via AccessMonster.com

In a report, is it possible for one text box to include multiple fields in my
table?
 
Yes, use concatenation.
Given FirstName and LastName fields... (values "John" and "Smith")
Create an unbound calculated text control with a ControlSource of...
=LastName & ", " & FirstName
would yield...
Smith, John
in the text control,

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Al said:
Yes, use concatenation.
Given FirstName and LastName fields... (values "John" and "Smith")
Create an unbound calculated text control with a ControlSource of...
=LastName & ", " & FirstName
would yield...
Smith, John
in the text control,


Perfect! Thanks Al. This is great.
 
Back
Top