Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    May 2003
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Highlight current line in 'datasheet' view (A97, A2k, A2k3)

    When I edit data, I open a new form. This form contains a subform that displays the data in "datasheet" view (based upon a query that links data from three tables). Now, I would like to highlight the current line. Is this possible when viewing data in "datasheet" view"? I have attached a sample DB.

    TIA, Jerry
    Attached Files Attached Files

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

    Re: Highlight current line in 'datasheet' view (A97, A2k, A2k3)

    I don't think it is possible to highlight a row in datasheet view. It is possible in a continuous form. Follow the link below to my website on which there is a free download on how to do this.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Highlight current line in 'datasheet' view (A97, A2k, A2k3)

    Mark is correct: you cannot highlight an entire row in a datasheet form (only individual fields). The database attached to <post#=382,292>post 382,292</post#> demonstrates some other ways to highlight records in a continuous form.

  4. #4
    Lounger
    Join Date
    May 2003
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlight current line in 'datasheet' view (A97, A2k, A2k3)

    So how do I highlight individual fields for the current row in a datasheet view? If this is possible, then I should be able to highlight the major fields, or all of them (using the same logic).

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

    Re: Highlight current line in 'datasheet' view (A97, A2k, A2k3)

    Using Conditional Formatting (available in Access 2000 and later, not in Access 97), you can specify that the control that has the focus is formatted differently from the rest. So this applies to only one control at a time - the currently active control. You cannot use it to highlight multiple controls.

    I repeat, what you want cannot be done in a datasheet form, but it is possible in a continuous form.

Posting Permissions

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