Change Background Of Txt Box
Feb 28, 2007
I have some code here that is changing the color of a txt box in my form based on the value in the text box. Everything is working great. The only problem is that I have a sub form with many tabs and many, many txt boxes. I would have to replicate this code hundreds of times....
Does anyone know a better (LESS CODE) way to look in the form and change the color of a txtbox based on a value. Something more generic. RIght now I am targeting specific txt boxes...
I just want a general statement that targets the entire form
THANK YOU ALL FOR YOUR HELP.....THIS IS A GREAT FORUM AND LEARNING TOOL....
CODE:
Private Sub Lower_Level_Concession_Inside_COUNTERS_AfterUpdate ()
If Lower_Level_Concession_Inside_COUNTERS = "2" Then
Me.Lower_Level_Concession_Inside_COUNTERS.ForeColo r = 255 'The New color.
Me.Lower_Level_Concession_Inside_COUNTERS.FontBold = True
Me.Lower_Level_Concession_Inside_COUNTERS.BackColo r = 65535
ElseIf Lower_Level_Concession_Inside_COUNTERS = "1" Then
Me.Lower_Level_Concession_Inside_COUNTERS.ForeColo r = 0 'The New color.
Me.Lower_Level_Concession_Inside_COUNTERS.FontBold = True
Me.Lower_Level_Concession_Inside_COUNTERS.BackColo r = 255
Else
Me.Lower_Level_Concession_Inside_COUNTERS.ForeColo r = 0 'The New color.
Me.Lower_Level_Concession_Inside_COUNTERS.FontBold = False
Me.Lower_Level_Concession_Inside_COUNTERS.BackColo r = 12632256
End If
End Sub
View Replies
ADVERTISEMENT
Jan 24, 2007
Hi,
I'm currently using MS Access 2002.
I use forms to display client info and i would like to know if the following is possible, and if so, how ?
When a clients installation date is older than 6months old (date is in a text box) i would like the form's background to change colour for that paticular client.
eg/ if the clients installation date was 7 months ago, the form's background would change red - but only to that client.
Kinds Regards
Chris
View 4 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
Jul 24, 2006
what's it?
I want to open the same form with different buttons (cos different criteria are attached to those buttons).
When i click i want the background to change based on the button.
So im asking for just one line of code: What's the vba to change background property of a form dynamically. cna't seem to find it :o
View 1 Replies
View Related
Aug 26, 2004
Im trying to change the background colour of some fields if the value is null or missing, but I'm not quite sure how to handle the coding. The fields in question are title, given name and surname, and if they are empty I want to change the background colour to highlight to users that they need to collect this information.
Any help that you can provide would be great!
View 4 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 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 11 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
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
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 9, 2013
I have a form with two textboxes that get their values from two different queries that counts records from table. If textbox1.value equals texbox2.value the textbox2.value back ground colour is green. If they are not equal textbox2.value goes red. Itried with using conditional formatting, but it doesn't work all the time as the form is not updating when it is opened.
View 4 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 27, 2005
Hi
I have a form, which users print out. On the screen, it has a light grey background, but I do not want this to be printed as it is just a waste of ink
Is there anyway of making the background colour "screen only"?
Chris
View 4 Replies
View Related
Mar 4, 2005
hello friends
if anyone of the access gurus here had a chance to download and use the Form demo from Microsoft website you would have notieced that the background is actually a bmp picutes of cloudes. Can anyone tell mehow they manage to put that pictures in the foms. i tried using the autoformat but the autoformat has specific formats and not the one i saw in Forms Demo from Microsoft webiste.
Please tell me how to include pictures like these in the form.
View 2 Replies
View Related
Dec 20, 2005
I would like to change the color of the actual access database background. I've done my forum searching and found many many threads explaining how to do this but i cant open any of the sample DB's. Access says the file is readonly and you need to be able to edit upon the first opening or something to that affect. I assume its becuse the sample is a newer or older access than im running(XP)
Sorry to rehash old threads but i cant get the info from them.
Can anyone help..Grey sucks ha
thanks
View 7 Replies
View Related
Sep 9, 2006
I want to run a pop up message "invisibly".
I have a flash file that jerks when run in access
but if i run it with a pop up it runs fine so I want
to run the pop up but, keep it hidden.
Without using minimize.
View 2 Replies
View Related
Jul 30, 2007
I am trying to put a jpg of a logo onto the top of a form and no matter what I do, it is imported with a white background! I have put it on a transparent canvas in Adobe photoshop, which usually works when I import it into word and other programs, but not access. I have tried looking at the properties of the image in access, but it says that the background is transparent. Help!
View 1 Replies
View Related
