Modules & VBA :: Combo Box Does Not Want To Change Background Color
Mar 1, 2015
I have some code to check a combo box if a date field is filled in, then the combo box can't be empty.I can make the error message appear, but the combo box does not want to change color and it does not recognize any other than value..This is the code that I have, and it does not work like I wish it could.(I took the database over from some one else and need to make improvements on it. the field names where not created by me).
Code:
Private Sub cmbCurrentStatus_AfterUpdate() '<<<<<<<<<<<<<<<< Working on >>>>>>>>>>>>>
If IsNull(Me.[STEP 1 4 check current status]) And Not IsNull(Me.[Checked__date_]) Then
MsgBox "Checked (date) can't be empty if Current Status is filled in!", , "Incomplete Form!"
Me.[STEP 1 4 check current status].Value = RGB(255, 0, 0)
Else
Me.[STEP 1 4 check current status].BackColor = RGB(255, 255, 255)
End If
End Sub
View Replies
ADVERTISEMENT
Jun 21, 2015
how to change background color of MSAccess Reports using VBA? How can I do border coloring. What are the vba codes for all color options like light green, light blue etc. How to change the font type to bold etc using vbaI did some changes to text box coloring in Detail Section on format click event.
View 3 Replies
View Related
Sep 21, 2006
I have a Data Access Page that I need some help with some of the code.
I need to do a comparison to see if the TimeStamp Control is less than one hour old. If it is, it should have the background turn red. If not it should stay white.
Form = BLine_Messaging
Control = TimeStamp
Code:<SCRIPT language=vbscript event=onload or=window><!--If (BLine_Messaging.TimeStamp.value > DateAdd("H", -1, Date)) THEN BLine_Messaging.style.backgroundColor="white"else BLine_Messaging.style.backgroundColor="red"end if --></SCRIPT>
View 1 Replies
View Related
Aug 26, 2015
I have installed Windows 10 & Office 13.The Background color of MS Access 13 is white in color which is irritating. Is there a way to change the background color?
View 7 Replies
View Related
Oct 25, 2005
:confused: <b>Hi all, can Access highlight the selected rows in table just like the spreadsheet in Excel??
Many thanks,
View 3 Replies
View Related
Aug 26, 2003
I need to change the background colour of a text box after a change to the field has been made?
ie.
Make: IBM (Background Color Grey - Default)
User makes a change to Make ..
Make: Toshiba - (Background Color changes to Yellow )
I'm trying to code this with the OnChange option on the TextBox but can't see to find the right code.
I was using Application.SetOption"Background", colour value with no success
View 2 Replies
View Related
Apr 30, 2006
I searched around but i couldnt really find or atleast understand how to do what i want to do. I want upon the user clicking on a checkbox for the background of the form to change to a set color?
View 8 Replies
View Related
Aug 18, 2014
I'm using the changebackgroundcolor.zip sample that I found here at Lebans site. URL....I'm trying to find a way to keep the color that I picked after the database closes. I tried to follow the example here URL....but couldn't get it to work.how to get the color to stay on the color that was picked from the dialog box?
View 1 Replies
View Related
Mar 6, 2008
Just wondering... is this possible.
I have a database with 200 clients. If a user pulls up a record and the customer's insurance has expired, is it possible to change the background color of the form so that this automatically alerts the user that this customer needs to be contacted and the record needs to be updated?
Or are there any other suggestions that may serve the same purpose?
View 1 Replies
View Related
Oct 3, 2013
I have a question related to a textbox on a form.
In my table (tbl_data) I have a field named Rating. This can be anything from 1 - 10.
On my form (frm_input) I have a textbox (created using the wizard so at the moment I'll call it txt_Rating).
What I would like to know how to do is:
If the value in the textbox is 0-5 leave the background colour of the textbox white with black font.
If the value in the textbox is 6-7 turn the background colour pale yellow with black font.
If the value in the textbox is greater than 7.1 turn the background colour Red with white font.
View 3 Replies
View Related
Mar 24, 2014
I have a listbox and whenever I clicked on a row it will highlight black background and white font color. How can I disable this or change the formatting?
View 2 Replies
View Related
Aug 14, 2015
Is it possible to run a query and have the background color of the query field be highlighted if a certain criteria is met?
I'd like to use the expresion builder if possible.
For example if the values in field A and field B do not match, then field C should be a yellow background.
If this is possible, how is it done?
View 1 Replies
View Related
Mar 28, 2013
I would like to change the Font and background color based on dates.
-I have a text box (Training Event) on a form populated from a field (Training Dates) in a query.
- I need the font and/or the background in that text box to change to red when the date is 12 month past, yellow 11 months past, white 10 months past and green for 9 months past.
View 3 Replies
View Related
Jul 13, 2015
I am using a continuous form and would like my users to be able to change a field background color to a light red by double-clicking. The user would also be able to change it back to white by double-clicking again.
The code I am using (below) changes the field background color for all records. I need my code to only change the field color of the current record and cannot seem to find how to do that. The field name is [System_CurrentStatus].
Private Sub System_CurrentStatus_DblClick(Cancel As Integer)
If Me.System_CurrentStatus.Backcolor = vbWhite Then
Me.System_CurrentStatus.Backcolor = RGB(234, 154, 160)
ElseIf Me.System_CurrentStatus.Backcolor = RGB(234, 154, 160) Then
Me.System_CurrentStatus.Backcolor = vbwhite
End If
End Sub
View 13 Replies
View Related
Jun 24, 2014
I would like to change the background color of a field that is the result of a Unique Values query. I am trying to get a list of invoices where all the line items are approved. I can't seem to get it to work the way I want because if even one invoice line item is approved it will show up as approved.
Is there a way to change the background color of the invoice field to red if ANY of the Approved line items are = False
View 7 Replies
View Related
Jul 28, 2014
in a continuous form i want to click on one record and have the one field change the background colour to highlight it. When I use the code: Field. BackColor = vbYellow it changes the background on all the records. Is there a code to say only for the record with focus?
View 1 Replies
View Related
Feb 5, 2006
I have a report card program that I use in my classroom. The program calculates letter grades for various sub categories.
For example, under the Primary Category Math, the computer will calculate a letter grade based on assignment scores and place the grade into a combo box for the sub category "Able to use a graphing calculator."
If I override the grade the program calculated for a student, I would like the text in the combo box to change to red for that student only. Then I can go back and quickly see which grades I have manually changed.
I just cannot seem to figure out the logic to use VBA that would check to see if a user has changed individual combo boxes.
Thanks ahead of time for any ideas.
View 2 Replies
View Related
Sep 28, 2006
What I want is in the combo box, I have a couple of options, say 1,2 and 3.
And I want the combo box to come up with different color when different option is selected.
I thought I have found out a way, with the following code to onClick:
If me.field.text = "1" Then me.field.backcolor = 255
The problem is, it's being shown on a continuous form.
And it changes the color on all the records. not just the one I am on.
Any thoughts?
View 1 Replies
View Related
Dec 30, 2004
I have two forms sourced from one table. if the address of a client has changed then there is a Command button that opens a form to enter the previous address.
What I want is for the text on the command button to change to red if there is a previous address filled in. I have seen it done but cannot copy the code. What I have is on the OnCurrent event of the (main form)
Dim InColor As Integer
InColor=255
Me.[Command126].Forecolor=(And what I want to say here is "If the field previousaddress is not null then ...)*255
Any ideas??? (I wanted to have the database completed before the New Year (less than 12 hours to go!!!)
View 2 Replies
View Related
Oct 23, 2014
I would like to change color of border button on mouseover event. How it to do?
View 4 Replies
View Related
Dec 13, 2006
hi every one
i have an application and the user was asking me to give him the ability to change the backcolor of the main form
i had done that with one color option.
but now he wants to mix two colors together
any one can help me with that , if code or sample would be posted, that would be appreciated .
thanks in advance
View 6 Replies
View Related
Aug 14, 2013
I'm using Access 2010. I'm passing a string into the OpenArgs of my report - works fine. In the report there are 3 rich text fields which may contain the text I passed in, and if so I want to change the color of that text to red so it stands out.
The value passed to the report changes so I'll need to use VBA in the detail's format section to check each of the 3 rich text fields.
View 5 Replies
View Related
Mar 6, 2006
How do I change the background color of a tab or can you? The form that I am looking at has a tab button, but it looks like a normal form for the background. It has the grid and has a color for the background. I have designed a new form and added a tab control. But the background is grey and I would like to change it. Please help, if you can. Thanks.
View 1 Replies
View Related
Jul 10, 2006
http://i54.photobucket.com/albums/g115/TomBP/changecolor.jpg
I want to change the background color to a plain white color. So I used the coloring bucket to fill it in. The problem is that it does not have any effect. In the picture you can see that the greyish color with the white dots remain.
This is some kind of standard template. Is there anyway I can remove it so I can fill in plain colors?
View 6 Replies
View Related
Feb 8, 2005
When I set the background color of a "rectangular box" to Normal (not transparaent), there are some fields that do not display - they are hidden behind the box. If I move the box, delete the hidden fields and add them back in, they appear fine. Is there a way to set the box color to allow all fields appear in front without having to delete and re-add all fields?
Thanks,
SKK
View 4 Replies
View Related
Apr 5, 2005
Hi,
I have design a form using the tab control. I need to add in color to make it more professional. Is there a way I can do it. I realised the filled /Back color icon is faded in color in design view.
Appreciate any help in this. Thanks.
View 2 Replies
View Related