Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Continuous Forms (2000)

    I have 4 fields on a continous form. as each one receives the focus I want to change the color to yellow the then back to white on lost focus. it works except for one small problem. it colors that field for every record and not just the one i'm an editing. is there a quick way around this that I am missing? As always...your help is appreciated.

    Steve

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Continuous Forms (2000)

    Although you may see many records in a continuous form, there is actually only one set of controls. If you set the background color of a control in code, it will affect that control in all displayed records.

    One solution is to use Format | Conditional Formatting. One of the options is to set a different format if the control has the focus.

    Another solution is to set the background color of the section to white, and the background color of the controls to yellow, and then set the back style of the controls to transparent. You MUST set the background color before setting the back style to transparent. The white background color of the section will show through in the controls, but the active control will show its own background color even though it has been set to be transparent.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Continuous Forms (2000)

    I use a similar technique to what Hans suggested with the transparent backgrounds, except that instead of changing the detail section color, I place a control (can be a box or a label) behind all my data controls and set its background color to the "standard" color.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Continuous Forms (2000)

    Attached is a demo file which illustrates how you can achieve what you want. It also shows how you can 'highlight' a check box and a button on a continuous form.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

Posting Permissions

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