Is there a way to use conditional formatting with a date? For instance, in my form I'd like the date field to turn red once a particular date has passed (to show that memberships are expired). Can this be done or am I better to just format a report of upcoming expiration dates?
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)
I need some help with a conditional formatting function on my form.
I have two seperate date fields and I need to set up a conditional format on one field so that when the date on this field is greater than the date on the other field, the text turns red and bold.
I am making a tracker to track events and how close we are to the next time the event has to be done. Specifically the event has to be done every 6 (180 days) months. I am looking for a conditional format formula that can color code when certain days have been hit. When it is less then 30 days or less from the next event color it yellow, when 31-180 color it green and anything past due color it red.
Using todays date as an example 12-Feb-15 it would be colored green. 150-179 days from now I would need it to be colored yellow. Anything beyond 180 days from now would need to be red.
It would only apply the formatting for dates that were equal to the date and +5 days.
I then tried Between Now() and Now() + 14
Same results
I then tried Between Date() and DateAdd("d",14,Date())
No change
I checked the property for the box and the back style is normal.
I am making the back color a light red. I tried to change the fore color red. Nothing.
I displayed what Date() was giving me in a text box control and I displayed what Date() + 14 was giving me in a text box control. They both were showing the correct dates, but my date, which was in between them, was not changing colors.
:confused: Hi. Does anyone know a way to change the colour of controls depending on their value in a continuous form?
I can change the colour of the current row in a continuous form, but I cannot adapt this so that it changes colour depending on the value (ie conditional formatting)
I have an accounting database with queues that list each requisition's important information (ID, vendor, dates, etc) plus the its status (not yet submitted, approved, ordered, delivered, filed, etc).
I'd like the font of the status field to change color depending on its value. I can't use the standard conditional formatting because there are more than 3 statuses.
I've tried an If/Then statement, but the form only looks at the status of the first record, then colors the font of the status fields for the consecutive records that same color no matter what their value. How do I get it to evaluate per record? As in, if the first record has a Submitted status, its font is blue, but the next record is Ordered so its font is red.
Here's my code, I used it in the OnOpen event for the form: If req_process_status_rec_id = 2 Then process_status.ForeColor = 13209 ElseIf req_process_status_rec_id = 1 Then process_status.ForeColor = 8388608 ElseIf req_process_status_rec_id = 3 Then process_status.ForeColor = 8388736 ElseIf req_process_status_rec_id = 4 Then process_status.ForeColor = 16737843 ElseIf req_process_status_rec_id = 5 Then process_status.ForeColor = 52479 ElseIf req_process_status_rec_id = 7 Then process_status.ForeColor = 6723891 ElseIf req_process_status_rec_id = 8 Then process_status.ForeColor = 16711935 End If
I have a continuous form that has several checkboxes in it. Only one is initially enabled and I want the first to impact if the others are enabled, but only in the currently selected record.
I tried VBA but quickly found that this enables/disables the checkboxes in ALL of the records. Next I found out about conditional formatting--which does exactly what I want, but only works on text boxes and combo lists.
Is there any way that conditional formatting can be used to impact (vs. be impacted by) a checkbox?
I have a continuous form and I'm using Conditional Formatting to color the controls that are not filled in.Ex: Expression Is = IsNull([txtNetProduct]). But I don't want to color the controls of a NEW record or row unless a record is created.
I have a continuous subform on a form. I have applied conditional formatting with expression is.. so that the formatting on one object (field on the subform) depends on whether there is anything in another field on the same subform named "Remarks".
My problem is that I this is not working to my expectations. First of all when the form with the subform is loaded the conditional formatting does not appear immediately. One has to run over the fields with the mouse with the hope that the conditional formatting appears.
Secondly the conditional formatting is not working well as they should.
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.
I wanted to use a conditional formating when in a subform the field "Field_Name" has the value "Case Status New" and then the field "New_Value" should become orange color.
I guess it can be put togheter like a formula (expression) in the Edit Formating Rule.
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
I have a continuous form that is used as a sub form, and one of the fields is a check box which ideally I would like to set not visible; however, I would like the font colour of the other fields to turn red if this check box has a value of false.
I have a form which basically has - employee, work done, hours and a calculated field (w/hour) of work done/hours
I can manually set the conditional formatting however as time changes targets will go up and it would be easier to update the targets in another 'admin form' (i can manage that part)
Its just referencing the other table to say the likes of :
if work per hour is greater than tbltargets.convtargetmid then vborange, if work per hour is greater than tbltargets.convtargethigh then vbgreen else vbred.
I want to add a conditional formatting to a combo box to highlight if the value is not on the list.There is a process to read in data from a 3rd party excel sheet that has truck arrival dates and times. My form displays this data and allows the internal users to change it. My form has the "Trucks" field as a limit to list combo box - so basically any data can be read into this field but internal we can only change it to trucks on the list (from the trucks table). I want to highlight where the trucks value is not in our trucks list.
I have a subform (called NAMES) on a main form (called MAIN) that lists names. Elsewhere on MAIN, I have a second subform (called ASSIGNED) that lists people that have been assigned.
When I double click a name on NAMES, it automatically adds them to the ASSIGNED list (who's record source is a table). What I want the NAMES form to do is conditionally format the NAMES form so that the record that's been added turns green. That way I can see who I've added and who I haven't yet added. Once I've added them all, the NAMES form is a simple list of all-green names. If there's a black name in the list, it's because I haven't yet added them to ASSIGNED.
I've tried a DLookup function, and I've tried a Value= conditional formatting rule, and neither one are working... I already got the 'double click to add' thing working, now I just need the name to turn green when I've added them.
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.
I have a form with 2 sub forms which have identical fields from different records. I want to use conditional formatting to indicate a mismatch between 2 of the identical fields. I have been told I should use [NewField] <> [OldField] but I don't know how to complete the syntax. If I call the first sub_form_1 and the second sub_form_2 and the field name is path_length on both, how do I compile the statement?