Conditional Formatting w/Multiple text boxes

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • John Kreps
    #1

    Conditional Formatting w/Multiple text boxes

    (acc 2002)

    I've got six unbound text boxes on a subform that has a white
    background. Each of those six boxes has an expression that when true,
    will change its background from white to another color. These text boxes
    need to go behind a single line of other bound text boxes (which show
    the actual record). I.e., the purpose of the unbound text boxes
    w/conditional formatting is to highlight the record/background with one
    of six colors.

    The problem is I don't know how to stack all the unbound text boxes
    behind each other without hiding each other. The background can't be
    transparent since that is what the conditional format changes.

    Anyone have any suggestions as to how I can hide/show a text box stack
    on others? (I've tried "send to back" which will not work due to the
    unbound text box's non-transparent background).

    John

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Tags: None
    • Fredg
      #2
      Re: Conditional Formatting w/Multiple text boxes

      You don't need to use those extra controls to change the back color of the
      control's that contain the data.

      If you have Access 2002, use the control's conditional formatting property.

      Select the data control.
      Click Format + Conditional Formatting.
      Set the Condition 1 drop-down box to
      Expression Is
      Write the expression in the text box along side the
      drop-down (do NOT use the = sign).
      Set the back color to whatever you want.
      Save the change.
      Do the same for each control.
      --
      Fred

      Please reply only to this newsgroup.
      I do not reply to personal e-mail.


      "John Kreps" <developersdex@ deletethiskreps .mailsnare.net> wrote in message
      news:3f5cddf7$0 $62083$75868355 @news.frii.net. ..[color=blue]
      > (acc 2002)
      >
      > I've got six unbound text boxes on a subform that has a white
      > background. Each of those six boxes has an expression that when true,
      > will change its background from white to another color. These text boxes
      > need to go behind a single line of other bound text boxes (which show
      > the actual record). I.e., the purpose of the unbound text boxes
      > w/conditional formatting is to highlight the record/background with one
      > of six colors.
      >
      > The problem is I don't know how to stack all the unbound text boxes
      > behind each other without hiding each other. The background can't be
      > transparent since that is what the conditional format changes.
      >
      > Anyone have any suggestions as to how I can hide/show a text box stack
      > on others? (I've tried "send to back" which will not work due to the
      > unbound text box's non-transparent background).
      >
      > John
      >
      > *** Sent via Developersdex http://www.developersdex.com ***
      > Don't just participate in USENET...get rewarded for it![/color]


        Comment

        • John Kreps
          #3
          Re: Conditional Formatting w/Multiple text boxes


          I don't believe I can utilize the condition formatting "wizard" in
          Access 2002 since I have more than 3 conditions...I have six, which is
          why I created six text boxes each with its own expression. I just can't
          get the "highlighti ng" textbox to show from behind the other 5.


          *** Sent via Developersdex http://www.developersdex.com ***
          Don't just participate in USENET...get rewarded for it!

            Comment

            Previous template Next
            Working...