May 13 2011, 01:18 PM
I have tried using the Fill/Back Color feature to change the fill/color of my form, but when I select a color, nothing changes. Can anyone explain to me why it isn't changing? Thanks in advance for any help.
May 13 2011, 01:25 PM
Are you doing the following?
In the Design View of your form:
1. Click on the Details section
2. In the Properties Window, select BackColor
3. From the dropdown, select a new color and hit Enter
Just my 2 cents...
May 13 2011, 01:34 PM
May 13 2011, 02:33 PM
I see... I think this is going to be hard to troubleshoot. Do you have full permission to the file?
May 13 2011, 05:28 PM
re DbGuy question, are you using the Detail section of the form?
May 14 2011, 12:52 AM
First off, as Shrek has alluded to, you cannot do this for a Form! It has to be done individually for each Section of the form, Header, Detail and Footer.
And secondly, if this Form is a Datasheet View Form, it cannot be done at all, in Form Design View. The only way it can be done for a Datasheet View Form is by going through Tools - Options - Datasheet
and changing the Back Color there.
And you need to know that this does not do this for a given Form, in your database, or even for all Datasheet View Forms, in your database, but for all Datasheet View Forms in all databases run on this computer! To do it on another computer running your database, you'd have to go thru the same thing to set it up, and the users on those computers might no like a red back color on all of their Datasheet View Forms.
Of course, if you're trying to do this on a Single View or Continuous View Form, and setting the Sections back color doesn't work, maybe you're looking at corruption.
Jul 12 2011, 06:58 AM
The strange thing is that Access 2010 allows to change the background of each datasheet form individually by modifying the background of rows and alternate rows. This can be done by double-clicking the form then via the /datasheet/ tab and <Background color> and <alternate row color>.
Now, I wonder if this is feasible for split forms?
Another question: I'd like to set the background of editable fields of a datsheet for to some color. There is no pre-condition. The conditional formatting allows changing the background of individual fields/controls without modifying the backgroound of a datasheet form. Nevertheless, it is very slow. is there any other method?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here