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.
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!
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.
This should be an easy one for somebody. I'm a newbie to access and I'm experimenting with a tabbed form. My problem is if I create a new form with (say) two tabs, the area to the right of the tabs(where more tabs would be inserted) is white and I don't know how to change it to blend in with the rest of the page. Hope I'm making myself clear.:(
Hi We have created some forms using (in some cases) the form wizard. As you may know you have to select a "Background Style" when using the wizard. Now we want to change the background from one of these styles to a colour - but when we select it in Properties and try to apply it, it seems to flicker but does not seem to have any effect. Can anybody help us out please ? many thanks ajm
I have been searching for a setting that enables me to change the background colour of a tab control on a form. It may be something obvious that I have missed.
Changing the type to 'transparent' and setting the form background colour does not seem to work.
I'm opening a form in snapshot view and would like the background colour of all the fields in the form to be a dark colour to show that it is in snapshot. the user then clicks Amend and the background colour would change to something lighter to show they can amend the record. Is there any way of on the OnClick event of the Amend button change all the fields (and there's lots) at once without having to name them all individually, ie:
Something that's been bothering me. I have a unbound subform which acts as a placeholder for other subforms rotating on it (by changing the SourceObject), that way all the relevant subforms appear in the right place when required. It works great except, it's this great big white box and there's no option to change the background colour anywhere. I would like it to be either transparent or have an option to change it to the same colour as my main form it sits on.
I have a form with subform that uses colour as background colour for all fields on the form, and also a very light background for the whole form. This outputs very well to PDF, retaining all of the layout etc.
However, consisting of over 100 pages I do not want any colour at all in the printed report, no do I want the colour converted to black or grey. Inkjet cartridges are just too expensive!
Is there an easy way to remove all colour before printing or do I have to design another report?
Here, what I am trying to learn, that background of the form change its colour automatically after sometime let say 1 min or after 2 min
I find the link on the web where more than 500 colour code are available, but not sure, how I can use [URL] ....
I can put this command on form_load() Me.Detail.BackColor = ????????? but question is how i can bring other colour into loop
Plus, if the user want to do any work on the same form, will this loop also allow the user to do any work, I mean form should not be stuck up in the loop of changing a colour...
Ok what I would like to do is have a switchboard with a number of command buttons on, each button opens to a form with a few fields within them.
Is it possible for the initial switchboard labels to be 'red', then as the related form is opened and populated the switchboard label turns 'amber' and once the form is complete the switchboard label is 'green'. See example piccie attached, to get a better understanding!
This is to enable multiple users to see at a glance the status of various jobs.
If anyone knows how I can go about this or suggest any alternatives, I'm open to suggestion.
...but I'v got a picture and I want to put a red box behind it so the picture looks like it has red borders, the problem is that the box always appears above the picture, I'm sure there must be a way to prioritize them or something but I can't find it!
I've been working on a database for quite a while now, and i've now given it out for testing, and i've come across a little problem. One of the users is colour blind, and the colour theme i've used throughout this database is causing him problems.
I have a function that can single him out when he logs in, question is, is there a way i can change the font colour for the whole database in one go through code??
I have around 12 forms with many controls and labels, i'm kind of hoping i don't have to name each control and label separately to change the font colour.
Please tell me that there’s some clever piece of code that can change the font colour on a form in one hit…..
I have a problem where the user has certain contraints in colour.
I am trying to change all the colours of labels in the database to purple.
Is there any way to declare it once in the database and all label statements will pick up the new colour. Saves me going through every form. Also there are other users who want to use the database with black.
First please accept my apologies if this has been done before. In the attached database I am going to have a form which is continous what I am looking to do is change the colour of the box which is in the background to the associated colour from the quote table for example
if they choose water then it will look at the TBLQuoteType and change the box colour to the colour which has been assigned to that value.
Hope this explains it ok I will continue to try and figure it out but I thought I could also use your expert knowledge.
Is it possible to get Access to automatically change the colour in a form field via code etc. My problem is that i would like to easily pick/see any out of date quotations for my customers, so when the quotation date is 30 days old the text changes to red. Any advice would be gratefully received.
I have a report which i am trying to format, I want every other row's details to alternate colour which i have done (See below)
I also have on my report, a checkbox and a text feild (not sure if i could use a rectangle and format that instead , it doesn't do anything i just need it to change colour)
chkbox name = "chkClean" Text box name = "txtclean"
I just want the back colour to go red if the check box is true and white if the check box is false
Please help
ANdy
Code:Option Compare DatabaseOption ExplicitPrivate m_RowCount As LongPrivate Sub Detail_Format(Cancel As Integer, FormatCount As Integer)m_RowCount = m_RowCount + 1 If m_RowCount / 2 = CLng(m_RowCount / 2) Then Me.Detail.BackColor = 15263976 'Change value to the color you desire Else Me.Detail.BackColor = 14811135 'Change value to the color you desire End IfIf Me.chkClean = True Then txtclean.BackColor = 255Else txtclean.BackColor = 16777215End IfEnd Sub
I have a bar graph on a report in ms access that represents 4 different risks ie count on the y axis and risk type on the x axis (low, moderate high and extreme)
Question: How do i get the each bar to automatically represent the colour based on the risk colours below?
Low: Green Moderate : Blue High : Yellow Extreme: Red
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
Hello fellow programmers, I have a tricky one for you. We have decided to split our local City up into different zones. Giving each zone a number and assigning it a colour. I have a form with all the customers who want jobs done in different parts of the city. This form has a text box on it called: Zone - (which has a 3 digit number it it). I want the colour of the text box to change depending on the Zone number, in the continuous Form view. So all the customers living in Zone=111, will have a Red background colour (color), all living in Zone=222 will have a Green background colour. I know conditional formatting through the properties of the Form can be used, but it only allows me to select 3 different situations. I have many more than 3 colours that I want to assign. I am working on a VB module to define what colour numbers from the MS Access Colour Map will be assigned to each Zone number. How can I now apply this module to the form, so when it opens, all the customers who live in Zone=111 will have a Red coloured background, those living in Zone=222 will have a green colour background, etc?
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>
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?
If it is possible to change the format properties of a menu/toolbar could someone please point me in the direction of some guidance/ let me know how to go about it I would appreciate it.
Specifically I'm trying to change the menu bar's /database window's property to match my forms (and company branding).
I've Googled various phrases in both UK and US spellings (to be on the safe side) and searched a few forums (this one included) and cannot find much beyond creating customised menu/tool bars.
Is it possible to change the colour of the text in a table. For example the word "URGENT" is selected from a combo box, and when viewed in the table it appears red.
