Conditional Formatting Custom Colour / Color
Jun 16, 2005
Is it possible to set a custom background color for conditional formatting? Don't particuarly want to do it via code, but I suspect it might be the only way. If coding is required, can someone advise how and where to put it?
You see, I have a form with a custom background colour. In the conditional formatting criteria, all I want to change is the font color for the control, but when the critiera is set it automatically changes the background to white.
Cheers,
Christine
View Replies
ADVERTISEMENT
Aug 3, 2005
Hi,
I have a continuous subform with a checkbox and a textbox. If the checkbox is checked, I would like the textbox to enable. Since using code will enable the textbox for ALL the records, I'm assuming I need to use conditional formatting.
The problem is that I'd like to set the Locked property of the textbox as well. Just disabling the textbox makes the text hard to read -- it's currently white forecolor, blue backcolor and disabling would make the forecolor grey. The conditional formatting dialog looks like it doesn't use the Locked property, so is there another way I can do it?
Along the same lines, I'd like to use a custom color for my formatting (my blue isn't a standard blue color). Is there a way to enter the numerical value for the color, rather than just pick one from the palette?
View 4 Replies
View Related
Oct 19, 2005
Hello,
I am trying to incorporate a traffic light system based on numerical scores from a calculated box.
I did a search on the forums and adapted a code which somebody suggested to conditionally change the colour of text. I want to do the same but only by changing the fill colour of an unbound, empty text box.
This is what I have tried, as well as other permuatations.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If [txtTag] >= "20" Then
Me![txtRHColour].BackColor = vbRed
Else
Me![txtRHColour].BackColor = vbGreen
End If
End Sub
Can anyone help me out please?
View 2 Replies
View Related
Oct 18, 2013
I have a subform that is purely to display information (no edits will be made on it). The subform has a special color on it (company color) that I can not deviate from. My problem is the first record in the subform (displayed as a continuous form) gets the focus. The font is white and standard access has a white background. My end goal would be to elimnate the focus for any record in the subform (if it is possible). I know that I could change the color with conditional formatting but the colors in conditional formatting do not match the company color.
View 4 Replies
View Related
Apr 16, 2014
I would like to have a conditional formating colour of green if the field contains a value like 10%..If the field has no value and is blank there will not be any background color change
View 1 Replies
View Related
Aug 23, 2013
I have an access form that has a dropdown box list of 10 choices.
For example:
The form states please choose 1, 2, 3 or 4 then the choice should print in BLUE.
They choose 5, 6, 7 or 8 Then it need to print in RED.
So forth and so on.
I am sure there is a code I need to type in the conditional formatting area that would reflect if [1], [2], [3], [4] then I choose the red color.
I do not know how to use VBL or coding.
View 9 Replies
View Related
Feb 5, 2014
I would like to have a Positive value with a green Background and a Negative Value with a Pink Background.
View 3 Replies
View Related
Apr 18, 2014
how to have a different conditional colour formatting for a plus and a minus number
If the field value is a Plus Number
The background colour will be Green
If the field value is a Negative Number
The background colour will be Pink
View 6 Replies
View Related
Sep 6, 2013
I'm using access 2003. I've got a textbox placed ontop of an image that I want to make it seem to disappear on a conditional format.
The back color property of the textbox I want to set is "13160660". How do I choose this colour when applying conditional formatting as I only seem to be able to choose from the swatch of 40 default colours and no option to define custom colours.
View 4 Replies
View Related
Aug 1, 2013
I have a form in datasheet with the fields "Date In" and "Date out" among other.
I want to be able to Change the backcolour of the "Date In" to red, yellow, or green depending on the length of time elapsed between current date and date in. This works fine on the conditional formatting, but now I only want to apply this formatting IF the "Date Out" is empty.
Access 2007.
View 3 Replies
View Related
Jul 21, 2015
I would like to know if this is possible using VBA ( or other method)
I want to determine the back color o a cell based on a color value stored in another cell in other word
backcolor of cell A = the value of cell B
So if I change the numbers of cell B (which is color codes) , backcolor of cells A change accordingly and it will have the color specified in cell B.
View 4 Replies
View Related
Jul 24, 2014
I have a report that I would like to have the rows be a specific color based on the value in 1 field on the row.
I have attempted to use conditional formatting but it will not work (IE, I can get font color to change, but not field boxes to have color).
The field is labeled [text144] based on the value in the field (1,2, or 3) I would like the field to be a different color.
i.e.
3 = green
2 = yellow
1 = red
View 4 Replies
View Related
Jan 7, 2015
I'm having a spot of trouble trying to get conditional formatting to work. I have an overview form which displays current quotes going through the system, the QuoteStartTime field is generated from the Now() command.I Would like if possible to show, 1 hour = Green, 2 hours = Amber and 3+ hours Red.
I've tried variations of
hour([QuoteStart])>1
DateAdd("h",1,[QuoteStartTime])
I've done this before with a date only field before, but working with time is taking too much time.
View 1 Replies
View Related
Aug 1, 2014
Need to confirm whether the Default formatting option in the Conditional formatting Dialog won't work in datasheet view of a form. Please note that all conditional criteria are working fine but not the Default Formatting option - only in the Datasheet view (In Single Form view the default formatting is working fine)
View 11 Replies
View Related
Apr 18, 2006
Hi Guys,
I've a question and I hope you can help me out.......
I'm trying to use Conditional Formatting Options on a Text box called "Date". I'd like that this box become Red if its value is between value1 from Text box "Start Date" and value2 from Text box "End Date" or Green otherwise (in this way the color change dynamically every time I change the values of Text Boxes "Start Date " and "End Date"). How can I do that? What I need to type in the Conditional Formatting Windows?
Thanks a lot for you help!!!!
Ciao Ciao
View 1 Replies
View Related
Aug 13, 2007
Hello
On my Database I have used Conditional Formattion to change the colour of the qty to highlight when the qty is getting low however its not as good as I would hope as there are different type of definition of quantity (D of Q) e.g. Each (single items such as a screw) and Roll (such as cord and tape)
Conditional formatting doesnt work well because if I have it as less than 10 the qty is in red, its ok for the each items however not the roll as 10 rolls of tape is more than we would need.
I am just wondering if anyone knows what the code would be to change the colour depending on the qty and the D of Q
All i have got so far is:
If me.qty <10 and DofQ = EA then
Now im stuck for the change colour part
Any help would be great
View 13 Replies
View Related
Sep 2, 2007
Hi Guys,
I'm after an easy way on being able to change the colour of a field once it a certain figure is reached
For instance
Standard field colour for anything 1-99
100+ changes to red
Would any be able to help me out please?
View 2 Replies
View Related
Sep 8, 2005
Does anyone know if there is a way in a report to display an entire row in a different color? I'm running a report based on a query and I need specific information to come up in RED. I read about conditional formatting but you can only apply it to a field in a report, but not to an entire row. Let's say I have a group of managers and I need to know the ones that are making more than $50,000 a year. I don't just want the salary to come in RED, I need the entire row (like name, last name, title, date of hire, salary, etc).
Any ideas?
thanks!
View 2 Replies
View Related
Mar 13, 2005
I have 2 subforms on a main form. I would like to compare the value in field 1 og subform 1 to field 1 of subform 2. I can't seem to get the conditional foramtting between the 2 subforms to work. Any ideas?
Jim
View 1 Replies
View Related
Mar 22, 2005
Good afternoon everyone
I am new to this forum. I have not done access development for about 6 years so I appologise for my rustiness.
I have created a form based on a query. The form is of type Datasheet. I have assigned Conditional formatting to the grid fields based on an expression evaluating a check box. This works fine and when I open the form the conditional formatting works great.
However, I am now trying to add this form as a subform in A.N Other form. The parent form has no datasource and is purely there to display some text values linked to unbound controls. I did this because apparently you cannot show form header for a datasheet view.
When I insert my child form into the parent there is no logical link. The behaviour of the form and subform works fine but the conditional formatting does not appear in the subform grid.
Why is this and how can I best sort this?
Any help would be appreciated, but please be aware I am not fluent in VB as I have been away for quite some time.
Bets regards
Philm
View 1 Replies
View Related
Mar 8, 2006
Hello!
I am stuck with a problem in my database.
I got a table that is looking like this:
On_Time
95%
96,88%
100%
100%
97,56%
There is more data there but this is the field i want to use. I got a form where i want a little box or something to be coloured in red if the average of all those percentages are below 95%. If its above 95% it should be green.
Can anyone help?
View 1 Replies
View Related
May 15, 2006
Hi. I have a problem with my conditional formatting. I have two fields field 1 (hours worked) and field 2 (hours per task). Field 1 shows the hours worked based on the difference between a start and finish time and field 2 shows the hours per tasked based on values assigned to the 10 task fields. I set the formatting of field 1 to show up in red if it did not match the value of field 2, which works fine most of the time. However, for certain values i.e. 5 or 6 field 1 still shows up in red even though field 2 has the same value i.e. both equal 6.
Could someone explain to me why this happens and offer a solution if possible.
Thanks for any help.
View 7 Replies
View Related
Oct 12, 2004
I have an Access form that is used for traffic counts. I have a total of 8 lanes of data entry rows (4 lanes each way).I have two text boxes that show the number of lanes in each direction for a specific location. I need the input forms to enable ONLY the number of rows displayed on the text box and disable the rest. I dont have a clue on how to do it. Tried conditional formatting. But the conditions overlap.
View 2 Replies
View Related
Oct 26, 2004
Hi,
I would like to format a report containg a PASS/FAIL field (electrical test results) so that the "Fail's" are printed in bold text, however when I use conditonal formatting #Name? is diplayed on the report instead of either Pass or Fail.
Any suggestions?
View 10 Replies
View Related
Feb 28, 2006
hi all
im trying to colour a cell that is null in datasheet view in a form. i can coulour values that are zero but i can't seem to find a way to colour null values.
any ideas??
View 2 Replies
View Related
Dec 6, 2006
How can I use conditional formatting to have a field change background colors if it is populated or stays white if left blank. Do I use field value, field has focus or expression.
View 1 Replies
View Related