Forms :: Continuous Subform With Conditional Formatting (Access 2007)

May 15, 2014

I have a continuous subform with a fairly complex snapshot query as its record source. I have controls on the main form to allow criteria parameters for the query and a command button to requery the subform based on the selected criteria. I also have conditional formatting on a number of the continuous controls in the subform (the conditions are fairly straightforward, i.e. highlight if null, true/false etc)

When the subform is (re)queried, it seems to repaint several times (3 or 4 although it appears arbitrary to me) before it eventually settles. And it really louses up the aesthetics as controls flicker between colours; sometimes I even lose the background colour on parts of the detail section, or controls disappear altogether. And this continues as I scroll down the subform (or even click anywhere on it)

I don't mind that the query itself takes some time to run - of the order of a few seconds each time - but I'd prefer for the screen to wait until the query is completed, and all of the CF applied, before refreshing itself, instead of 'sweeping' top to bottom repeatedly. It's a snapshot query so once it's run, there should be no changes to the dataset.

I've tried Application.Echo but it has no effect whatsoever.

View Replies


ADVERTISEMENT

Forms :: Conditional Formatting On Continuous Subform?

Jan 4, 2015

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.

View 5 Replies View Related

Forms :: Repaint Continuous Subform With Conditional Formatting

Jun 2, 2013

I have a continuous subform with conditional formatting whereby when I select a record the row is highlighted.

It all works fine except that I have to requery the subform to enable the conditional formatting to work.

The Repaint method does not work on the subform.

View 1 Replies View Related

Forms :: Conditional Formatting Of Controls In A Continuous Subform (Access2007)

Aug 28, 2013

I have a continuous subform with multiple controls (textboxes) per row.

I'm trying to set up conditional formatting such that certain textboxes are highlighted based on comparisons with other textboxes within the same row/record.

What's bothering me is, I have managed it for one, but struggling to do it for others!

For example - I want to highlight 'similar' records (i.e. possible duplications) - and have managed this by adding a textbox across the length of the row and applying the following CF expression :

Quote:

DCount("[ID]","[tblMyTable]","[ID] <> " & "txtID" & " And [Field1]=" & "txtField1" & " And [Field2]=" & "txtField2" & " And [Field3]=" & "txtField3" & " And [Field4]=" & "txtField4" & " And [Field5]=" & "txtField5")>0

Works brilliantly - highlights all records where fields 1 thru 5 hold common values.

Now I want to highlight where two fields within the same record are different (i.e. they are driven by different data but should hold the same value)

Am trying this :

Quote:

"txtField3"<>"txtField4"

But it's not working - it's highlighting pairs of fields even though they do hold the same value.

Even tried switching it for a DLookup (which seems like doubling up on effort, but just to see if it worked)

Quote:

DLookUp("[Field3]","[tblMyTable]","[ID]=" & "txtID")<>DLookUp("[Field4]","[tblMyTable]","[ID]=" & "txtID")

But no dice? I can't figure out why the same basic logic which works so well for the first CF, doesn't hold for the second one.

View 5 Replies View Related

Conditional Formatting Continuous Forms

Dec 2, 2005

: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)

Ta

View 5 Replies View Related

Conditional Formatting On Continuous Forms

Nov 7, 2005

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

Thanks!

View 3 Replies View Related

Forms :: Conditional Formatting Of Control On Continuous Form

Feb 2, 2015

I have a continuous form on which where each record has many controls, including control (A). I wish to set the colour of this control based on the contents of another control (B). Control B is a memo format and is placed behind another control making it hidden. The idea being that the user can then click on control(A) and look at supporting information from Control B on another form.

Conditional formatting cannot be used since this only allows conditions based on the control (A), not (B). Event procedures cannot be used since they all depend on making a record the current record, and I want the user to immediately see when further information is available. When I apply VBA code using an 'on load' event it is action for all records on the form in a way that if only one record has extra information, all records are flagged in this way.

View 6 Replies View Related

Forms :: Conditional Formatting In Continuous Forms

Apr 14, 2014

I have a drop down box on a continuous form called (cmbItem).When the users choose Option 6 (Other) and on the open event I wish to show another field txtOther which allows the user to give a description of what 'other' means but I only want to show the field for that record. (the user could potentially have more than one record as other)Using conditional formatting I have managed to change the colours of the box so that the background is the same colour as the form unless other is chosen when it reverts to white. However I can't do the same with the border as this is not one of the options provided.

View 2 Replies View Related

Forms :: Subform Conditional Formatting If One Field Has Value?

Apr 10, 2015

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.

View 4 Replies View Related

Forms :: Subform Conditional Formatting Of Sorts

Nov 2, 2014

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.

View 9 Replies View Related

Conditional Formatting Of One Button On Continuous Form

Jul 17, 2005

Hello there,

I was wondering if any of you experts out there know a way to help me out here.
I was wondering if it is possible to color the text on the last pressed button on a continuous form different from all the others, so people will know which one they pressed last?
I've been trying a lot of different things here but i'm stuck. All i can get done is that all the buttons turn a different color, but doesn't solve anything.

I hope some of u can help me out here.

Greetz,
And thanx in advance,
Rutger

View 7 Replies View Related

Continuous Form - Conditional Formatting On Option Box

Apr 24, 2015

I have a continuous form. On which I have a frame and three option boxes with values 1, 2 and 3 what I am trying to do if one record is selected in option box other text boxes of the same record turn red I am using this code which works perfectly expect that it's doing for all records. I want that particular record to turn red.

Code:
Private Sub Form_current()
FormatGroup
End Sub
'
Private Sub Frame53_Click()
FormatGroup

[Code] .....

View 1 Replies View Related

Forms :: Default Formatting Option In Conditional Formatting Dialog?

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

Forms :: Access 2007 - No Records Shown When Continuous Form Is Opened

Dec 21, 2014

IN Access 2007 when a Continuous form is opened there is no records shown.

Only after hitting the page down records are shown.

View 1 Replies View Related

Access Reports - Conditional Formatting

Aug 7, 2014

I am making a planner in the access 2010 report. I am showing which activity finished when but I also want to highlight/ shade the cell to the corresponding month on the planner to the right. See picture above. I tried conditional formatting with date rage 1/1/2014 and 31/1/2014 but it does not gives me accurate result.

View 3 Replies View Related

Conditional Formatting A Table In Access 2013

Nov 4, 2013

I have a table in access and I need to format it so that when column "Status" = "Closed" column "Closed" = "yes". so it will automatically mark column "Closed" "yes" if "status" says "closed". Instead of having to change both columns all the time.I know how to do that in MS Excel, but is it possible in MS Access 2013?

View 3 Replies View Related

Forms :: Use Conditional Formatting With A Date?

Jul 11, 2013

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?

View 1 Replies View Related

Forms :: Conditional Formatting For Checkbox?

Nov 24, 2013

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?

View 6 Replies View Related

Forms :: Conditional Formatting Not On New Record

Jun 22, 2013

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.

View 3 Replies View Related

Forms :: Conditional Formatting In Tab Control

Nov 28, 2013

I have a Tab Control "box" on a form called PatientUpdate.

I would like to apply a conditional format on the second tab named Grp Bkg. In its properties, the Page Index is 1.

In the Tab resides a subform called Patient_GroupBooking which contains the field GroupBkg_Name.

CONDITION: if [GroupBkg_Name] is not null, make the tab Grp Bkg's font color red instead of the default black.

How to write this in Form Design Tools, Format, Conditional Formatting or other.

View 2 Replies View Related

Forms :: Change Color With Conditional Formatting

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

Forms :: Conditional Formatting Field Color

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

Conditional Formatting Text In Outlook Email Generated From Access DB VBA

Oct 9, 2012

I can generate an email by clicking on a button on a MS Access Report. In the body of the resulting Outlook email you have formatted text. I have also included an array of values which are displayed in this email but I need to highlight certain items in the array in red based on whether or not another column for that record is checked. Here is an image of the email. Notice that I have circled "ZWO" and that it is red. I need for this to happen programmically.

View 7 Replies View Related

Forms :: Conditional Formatting For Choices And Printing In Color

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

Forms :: Conditional Formatting On A Lookup Field List

Mar 5, 2014

My table fields are as follows:

1. Issued? (This is a lookup field with the following lists "Yes"; "No"; "NA")
2. IssueDate

I created a subform bound to the table.I wish to accomplish the following on the form:

1. If "No" is selected on the [Issued?] field, I want the [IssueDate] to gray out.
2. If "Yes" is selected, I want [IssueDate] to be required.

I set Conditional Formatting as follows:

Expression is ([Issued?]="No"), condition is disabled.

When I tested it, [IssueDate] grayed out when "No" was selected. However, when I select "Yes", it still remained grayed out.

View 5 Replies View Related

Forms :: Conditional Formatting Based On Value In Targets Table

Oct 15, 2014

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.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved