Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a tax return form, in single view, which has a set of check boxes that are not appropriate to corporation tax returns. When the data for the field is selected from the [TRType] I would like the text box to go grey. So the user selects the [TRType] field to be Corporation Tax" and I can use conditional formatting to get the text box to grey over, no problem. The nub is how to keep the text box transparent when the [TRType] is not "Corporation Tax". Can this be done please?
    Attached Images Attached Images
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Doesn't that happen automatically?

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Hans. No it doesn't happen automatically, but I did expect it too. I created the text box, the conditional format does not have a colour of transparent.
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Perhaps it's better to change the formatting in the On Current event of the form and in the After Update event of TRType.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If I leave off the conditional formatting, I can make the background of the text box be set to transparent. Adding the conditional formatting, I'm using Access 2003, causes the background to be be changed to solid when the conditional formatting IS NOT ="Corporation Tax" and functions correctly to the chosen conditional formatting colour.
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  6. #6
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Dallas, Texas, USA
    Posts
    113
    Thanks
    3
    Thanked 6 Times in 6 Posts
    Stephen,

    From your description, it sounds like you want the inappropriate buttons disabled (greyed out). If that's the case, you need code in the Change event of the TRType check box to set the Enabled property of the text box to False, and you can forget about conditional formatting, which won't actually disable the control.
    David Gray, Chief Wizard
    WizardWrx
    Irving, Texas, USA

    WizardWrx Web - Technical Articles and Free Software
    You are more important than any technology we may employ.

Posting Permissions

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