Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012

    Unanswered: Inlcude both text and calculated values in one label?

    I want a label that reads from (year) to (year) on my report in access 2010 where the year is filled in by a field on another form. I can split it into 4 labels and have it work as long as I line them up evenly, but I also need them to only be visible if a certain qualification is met. It will be easier to add the code to make it visible if there is only one label because I also need a replacement label that also has a mix of calculated values and text.

    So is there a way to have text in my label along with the values I pull from another form field? And how would I do this?

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 17
    In this case, I would suggest that you use an unbound text box rather than a label. Then you can either control its value with a function, or through the report's events.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Tags for this Thread

Posting Permissions

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