Results 1 to 9 of 9
  1. #1
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291

    Make records switch between 2 shades so you can see across a row easier

    I am new to 2010, some of my continuous forms change shades every other record so you can see them easier and some are all one shade, how do you get access to change the shade every record?

    Thanks for help.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    In 2007 it's in the properties of the detail section, on the format tab: "Alternate Back Color"
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291
    Does it work for data sheet too?

  4. #4
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291
    That does work for continuous view but not data sheet view, is there another option for that or do you just live with the background it provides?

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    To be honest I don't like datasheet view and never use it. A brief test confirms that it doesn't work. I can't think of another option offhand. I know a code method for reports, but not for forms.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291
    What would you use if you needed to display several records with several fields? I also have a sub that is called after update of any fields.

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I use continuous view. I feel like I have more control over the look, and you can have buttons in the detail section which you can't in datasheet view. Your sub should work the same, as each textbox still has the same events.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  8. #8
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291
    I like continuous view but one think that is very nice about datasheets is you can have a bunch of columns and sometimes you just want 4 columns other times you want them all. It is easy to hide and unhide columns, is there a way to do that in continuous view? I use continuous view often but I think I would have to hard code in hiding.

  9. #9
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I don't think I've ever had a situation where the columns I wanted to display changed that much. It would certainly be trickier in continuous view.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Stuck on "Switch" expression.
    By andypandy in forum Programming
    Replies: 3
    Last Post: 07-04-2010, 05:12 PM
  2. Replies: 6
    Last Post: 04-06-2010, 03:00 PM
  3. Replies: 6
    Last Post: 03-27-2010, 11:18 AM
  4. Loop through Records and Make ID
    By rob4465 in forum Programming
    Replies: 3
    Last Post: 01-14-2010, 10:46 AM
  5. Switch and Tables
    By UtilityRyan in forum Database Design
    Replies: 0
    Last Post: 06-12-2007, 03:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums