Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 8th, 2007, 07:45 PM
Registered User
Join Date: Mar 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Changing b/ground col in subform d/sheet

Hi, hope some of you guys can help me with this....(Access 2003)

I have a sweet looking database with pages and subforms. The subforms are in datasheet view. So from a design perspective the dark background in the datasheet view is ruining the user experience. How do i change the background color in datasheet view to white or similar?????

Old March 13th, 2007, 07:01 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG

The background color of a subform in datasheet view is determined NOT by Access properties, but by your Windows display properties.

Close Access.

Right-click anywhere on your desktop where there is not any icon.

Select Properites

Click the "Appearance" tab.

You will see choices for your color scheme. Click on the Window Text area. It will be the offending color of which you spoke.

The field called "Item" will change to "Window" and the "Color" field will also turn to that color.

Click the color dropdown button and change it to white or some other desired color.

Click OK.

Reopen Access. Your subform's background color will be the color you desire.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Old March 13th, 2007, 07:08 AM
Registered User
Join Date: Mar 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts

Many thanks Greg, ill give that a try... Dom

Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Workbook,Copy Sheet,Move Sheet, Close/Save ptrussell2009 Excel VBA 0 June 13th, 2008 02:28 PM
access function in data sheet(another sheet) jani Excel VBA 1 May 21st, 2008 07:15 PM
Subform data sheet view question amob005 Access 1 December 5th, 2006 09:13 AM
Changing sheet code name bdancis Excel VBA 1 June 2nd, 2005 03:49 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.