Forms :: Highlight Red Based On Value

Apr 14, 2014

Code:
Private Sub Combo1309_AfterUpdate()
If Me.Combo1309.Value = "Yes" Then
Me.Text1307 = Environ("UserName")

ElseIf Me.Combo1309.Value = "No" Then
Me.Text1307 = Environ("UserName")
End If
End Sub

I am using the above code to capture the login information. Is it possible to add a second criteria to the Me.Combo1309.Value = "No" that also highlights the Textbox (Gender) Red? Ideally, the value in this textbox would be switched to the opposite, but this option might be more trouble then its worth.

View Replies

Reports :: Conditional Formatting Based On Two Fields - Highlight In Red?

Feb 17, 2015

So i have two fields I need to tie together for conditional formatting

If the "status" field says "RETURN" and its over "30" days then I need to highlight it RED

If the "status" field says "AVAILABLE" and its over "90" days then I need to highlight it RED

Is this possible?

View 5 Replies View Related

Forms :: Highlight A Day If It Is Current

May 14, 2014

How would I go about writing some code to highlight the current day if a day field in a form matches.

i.e. I have a schedule form that has a field that has the day manually entered, so Monday, Tuesday etc.
And on the top of the form I have a text box set to =Now() and the date format set to dd mmmm - dddd

And what I want to do is make it so what ever the current day is, any records in the form that match the current day will be highlighted.

View 9 Replies View Related

Forms :: Highlight To Update Form?

Oct 25, 2013

I have a form that I need to update whenever a chosen business name changes. This is tied to a search function that updates/changes the business name, and this works fine. What I now need it to do is when the name is clicked on the table (which updates the respective business name) I need everything else to update with it.

I have tried refreshing the business name, the form, even the records themselves with onClick and onChange functions, but it still doesn't work.

Re-reading this I realize it doesn't make much sense, but hopefully the attached database will clear things up. When you type in the info in the search box, all the stuff in the right corner changes accordingly. If you click and highlight anything in the box in the center instead of using the search function, the business name at the bottom changes but everything in the right corner remains unchanged.

View 2 Replies View Related

Forms :: Search Form Specify Row Highlight

Oct 24, 2013

I have a form that acts as a search form where the user inputs a string of text which then updates and filters a list box. For some reason when it does this it highlights the 2nd row on that list, even if there is no data there. How can I get it to automatically highlight the first row? The database is attached and the form in question is FRM_SearchMulti.

View 1 Replies View Related

Forms :: Highlight Mandatory Controls On A Form Tab

May 15, 2013

I am trying to provide a visual highlight for users of a multi tabbed form. I do a check as users go from tab and tab and i.e. on exit event and I would like to highlight all mandatory fields that have been left incomplete.

I did a test with one control and it worked as expected with the after update event of the specific control.

I then altered the code to add another control, but it does not work as expected. It only highlights one control and not the other. I just recently started using vba, I adapt the code to fit multiple controls and make it work as expected.

Private Sub Ctl2_frm_tab1_Exit(Cancel As Integer)
If (Len(Form_2.cmb_arName& "") = 0 Or IsNull(Form_2.cmb_arName)) Or _
(Len(Form_2.cmb_val & "") = 0 Or IsNull(Form_2.cmb_val)) Then
Cancel = True
MsgBox "Please complete the highlighted control", vbCritical + vbOKOnly

[Code] .....

View 3 Replies View Related

Forms :: Highlight Duplicates In Form And Subdatasheet

Mar 26, 2014

I have a form which has a subdatasheet attached to it. there could be 1000 records in the main form but only 10O records in the Subdatasheet that match the records in the main form , these are linked by a "product number" .

Is it possible for the row in the main form to be "red" where there is data in the Subdatasheet that is matched by the "product number".

View 5 Replies View Related

Forms :: Highlight Sections Of Continuous Form?

Feb 9, 2015

I have a continuous form that shows the results from a query like:

Red
Red
Red
Green
Green
Green
Yellow
Yellow

And I wanted to know if I can some how highlight in a white/yellow alternating color like for instance starting with the three reds being white then the three greens being yellow then the two yellows being white and so on. Maybe through conditional format?

View 2 Replies View Related

Forms :: Conditional Formatting - Combo Box To Highlight If Value Is Not On The List

Feb 23, 2015

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.

View 2 Replies View Related

Forms :: Deselect Or Remove Highlight From Item In Listbox

Jul 2, 2014

I am using Access 2010.

I have a form with three listbox. My issue is this, when I go from listbox to listbox the selected item in the previous listbox is still selected.

I would like it so when I go to the new listbox, then the previous listbox selection will no longer be highlighted.

I use the follow code, which works but the user has to double click on the listbox with the focus to make a selection.

Code:

Me.listbox.listindex = -1

I have the code in the lost focus event of the listboxes.

Is there a way to prevent the double clicking?

View 7 Replies View Related

Forms :: Way To Highlight Duplicates Across A Number Of Records On A Continuous Form

Jan 1, 2015

Is there any way to highlight duplicates across a number of records on a continuous form (conditional formatting I presume)? My continuous form is filtered on load to show only the records relating to the specified date (specified before opening the form), and there is one field that I would like to highlight if there is a duplicate value in the same field on another record on the form. Is this possible?

View 1 Replies View Related

Forms :: Highlight Some Fields On A Form If Their Value Differs From Previous Record

Dec 9, 2014

I wish to highlight some fields on a form if their value differs from the previous record.

I'm OK with the code to determine this, but unsure as to where to put the code to set the fields initially?

I have two strings txtPrevPayment_Method and txtPrevProduct.

Where can I set them 'once' to be the same as the first record loaded in the form. Then in the Current event I check if they have changed and set font colour accordingly.

View 14 Replies View Related

Forms :: Highlight Unbound Subform Record That Matches Other Subform Record

Jan 22, 2014

I have two unbound unlinked subforms residing on a 3rd unbound main form. When I enter the current record on Subform1 I would like the matching record(s) on Subform2 to be highlighted or otherwise formatted. I can get this to work for only the first record on subform2 due to the way I have my code setup on Subform1:

Code:
Private Sub Accounting_Unit_Enter()
'find where AUs match. only works for first Subform2 record
If Me.[Accounting Unit] = Forms!MainForm.[Subform2]!AccountingUnit Then
msgbox "Match"
End If
End Sub

My thought was that I needed to reference the Recordset of Subform2 and search for all AccountingUnits that match the current AccountingUnit of Subform1,

View 6 Replies View Related

Highlight A Row In A Table .

Feb 1, 2006

Hello ,

I have a problem , I need to highlight a row in a table .How can I do it ? can i make it using query ?

View 1 Replies View Related

Highlight A Feild

Dec 1, 2004

Is their a way to highlight a feild. I am using the duplicate function but after the record is duplicated their are certain feilds that have to be changed, how can i highlight them somehow. ANy ideas??? The feild is Price???

Thanks Very good forum

Pete

View 4 Replies View Related

Highlight Current Record

Feb 14, 2006

I have a form with data in formview. When I select a record I want it to highlight with a specific color.

How can I do that?

View 1 Replies View Related

Form Focus Highlight NOT

Jul 7, 2005

How do I turn off the highlight feature when a control on a form obtains focus?
Fen

View 2 Replies View Related

Highlight Search Results

Jan 2, 2006

Good Day All,

I have a wild card search query (Like "*" & [Forms]![search]![Text0] & "*") that works very well. I want to be able to have the phrase that user types in highlighted when it returns the search results on a form. I found the following thread that asks the same question using Conditional formating, but the suggested answer doesn't work. Any ideas?

http://www.access-programmers.co.uk/forums/showthread.php?t=73845&highlight=highlight+search

View 3 Replies View Related

How To Highlight Cell In Subtable

Oct 1, 2012

Ok, there is one main form and a subform which is linked directly to a table. A VBA routine checks entries and flags certain rows for errors. We want to highlight specific cells that are out of tolerance.

Been playing around with the Me.ActiveControl.BackColor = vbYellow

But if this can be done to a particular cell on a table, and if this can be done using VBA.

View 14 Replies View Related

Highlight Key Search Result

Jun 3, 2012

How to I can Highlight key search result.

View 14 Replies View Related

How To Highlight A Record In A Continuous Form

Nov 11, 2005

Hello all,

This is my first post. I have been trying to find a solution for the following issue. I have a Continuous form and I would like to highlight the record by clicking on any of the fields in that record, tried everything with no luck, any ideas?

Thank you

View 4 Replies View Related

Auto Highlight In Form Fields

Sep 19, 2006

Hi guys

I just built a tracking database (I can't post it because it contains PHI, and I do hope I don't have to) and it's been giving this issue starting today.

When I am in a field the cursor automatically goes to the end and highlights everything between the end and where I click. So if I mistype the third character I need to delete everything from the end to the third character to edit it.

It just started doing this when I loaded it up. Does anyone have any idea?

Thanks

View 1 Replies View Related

Highlight Tabbed/current Field?

Dec 6, 2006

When tabbing through a form is it possible to highlight the field you have tabbed to?

View 1 Replies View Related

Highlight Field Instead Of Showing Blinking Caret

Mar 26, 2008

Here's one for you guys:

My vision-impaired staff are having trouble seeing the blinking caret when they tab over to the next field in a form. Is there a way to highlight the newly-selected field instead of just having a thin blinking caret to guide the way?

View 4 Replies View Related

Highlight Keywords In Search Results In Report

Aug 5, 2006

Hey guys
it's been a long time since i've been here
but i again need your help

my job asked me if it's possible to have keywords highlighted in search results in report
am i clear?
meaning, when you search for keywords in one of the fields, and then your results come out in the report, can they be selected, like in Word, or in searches on the Internet, like when doing a search on Monster, all your keywords will come out in red, that way you can easily read the results

so can this be done in Acess?

View 11 Replies View Related

General :: Highlight The Current Record In The Subform?

Sep 23, 2013

I have synchronized a form with a subform with the following code:

Private Sub YourField_DoubleClick() 'this code is behind the subform
Dim rs As Object
Dim strLinkValue As String 'value in link field of the subform
strLinkValue = Me![NameOfLinkFieldOnSubform].Value
Set rs = Forms!YourMainForm.Recordset.Clone
rs.FindFirst "[NameOfLinkFieldOnMainForm] = '" & strLinkValue & "'"
Forms!YourMainForm.Bookmark = rs.Bookmark
End Sub

Every thing works fine but now I would like that the row in subform remains selected in the subform when the user doubkeclicks the record in the subform.Now after doublecliking the subform highlight the first row.

View 4 Replies View Related