text box with multiple controls?

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

Carma via AccessMonster.com

In a report, is it possible for one text box to include multiple fields in my
table?
 
A

Al Campagna

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."
 
C

Carma via AccessMonster.com

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,
Click to expand...


Perfect! Thanks Al. This is great.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reports 2
Display multiple records from same ControlSource 1
how to put multiple results in one text box 2
How to wrap word in a text box in a report 2
Rich Text Format 0
multiple records in a text box 1
Impossible task? 2
Change text box background color depending on value in Label Reports 1

Top