Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2012
    Posts
    4

    Unanswered: How do I have text box label show record data?

    I have a text box included in a group footer that shows the count of a particular record. How do I have the label for that text box show the record?

    The field is called Genre. For example, for the Rock albums, I would like it to display

    Total Rock Albums

    and so on for Jazz, Blues, etc.

  2. #2
    Join Date
    Dec 2004
    Location
    Connecticut
    Posts
    85
    You have to make the "label" an unbound control with a Data Source that looks something like ="Total "& [Genre] &" Albums". The quotation marks tell it to put in some text, the ampersand tells it to concatentate it with whatever comes next - in this case the contents of your field - and then concatenate some more text.
    I've used these forever when creating form letters.

  3. #3
    Join Date
    Apr 2012
    Posts
    4

    Perfect!

    Quote Originally Posted by trowe View Post
    You have to make the "label" an unbound control with a Data Source that looks something like ="Total "& [Genre] &" Albums". The quotation marks tell it to put in some text, the ampersand tells it to concatentate it with whatever comes next - in this case the contents of your field - and then concatenate some more text.
    I've used these forever when creating form letters.
    That worked perfect. Half of the battle of this stuff is knowing the correct terminology in order to ask the right question. Thank you for the solution, much obliged!

    Guiseppe

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •