hi all
i have a continous form which is bind to a datatable.I want to show a particular coloumn with different background cols depending on its values.
On the page load i m doing this like-
If txtprodtype.Value Like "*atm*" Then
txtprodtype.BackColor = 255
End If
but the problem is that it checks this only for the first record.how can i apply this to all of the records??
Thanks
Hi
In MS Access,
I want to one form, whose color is red, but I want to make the tag color to be red. But the Name section of the tag don't need to change the color, only the content section. I don't know how to change the tag color.
Please let me know how to change it.
Please open the example and see it.
Thanks.
After Searching the Web, I couldn't find anything that did something as simple as this, choose a color....
So here is one!
Waste not, want not....please feel free to use it!
Hey guys..
I have a form that displays inventory of goods.
there is a list box with a list all property. If they items are sold a sales order number appears next to it. Now with that in mind how can i have something that if there is a sales order number on that item then highlight it with a color?
Is there any way to change the color of the command buttons? I know you have change text inside the button, I want to change the whole button color.
View 2 Replies View RelatedMy list box on my form has the fore color set to 255 or red yet it still displays the first column in black and the rest in red. Am I missing something? Why isn't it all red?
Wulf
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
Hi,
I have a question.
Can we do the color inside the List box?
Suppose we 10 rows data inside the List box, I want to put color every other lines.
Can we do that?
Thanks.
Is there a way to change the background color of just one column in a subform?
Thanks in Advance - John
Hi everybody,
I'm trying to make the backround color of a text box "prova" (short date value) changing according to the values of other two different text boxes "StartDate" and "EndDate" (both are short date values).
I'd like the backround of prova to be blue if its value is between StartDate value and EndDate value.
So in the code builder I made this function:
Private Sub prova_AfterUpdate()
If Me.prova.Value > Me.StartDate.Value & Me.prova.Value < Me.EndDate.Value Then
Me.[prova].BackColor = vbBlue
Else
Me.[prova].BackColor = vbWhite
End If
End Sub
Is that correct?
Thank a slot for your help :confused:
Sometimes the simplest of questions can be the hardest to find the answer to. I have spent the last 2 hours searching for the answer to this one. I'm sure it's on this site somewhere but the search is running way to slow for me to be of any use.
What exactly does the numeric color codes in VBA represent? I have downloaded a score of color pickers. utilities and none use these numbers in the way Access does. Ideally, I'd like to find a utility that will allow me to specify a particular color and then give me the corresponding code for that color.
TIA
I am using Access 2007 and trying to set the BackColor property of a text
box on a form using VBA Code in the Form_Open event with code like this:
Me.txtName.BackColor = <some global variable>
Here's the thing: In order to get the correct color numer, I first pick my
desired color from the palette to see its value. In this case, a very bright
red comes up as #ED1C24.
In Access 2003 and earlier, this value would be represented as a long
integer, not a Hex. So, my question is how to get the HEX value converted to a long integer??
The BackColor property is supposed to be a long integer data type, but that is NOT what the design interface is presenting to me!
Why did Microsoft change the BackColor property of form and report objects from long integer representation to Hex?
CONFUSED!!
This is a very stupid question, I'm sure...
I want to get Access to find a cells that have a certain value and make them a particular colour so that they can easily be seen by database users. I could also make the font a different colour. I've tried getting the builder to do this in the query I run (for the column the fields appear in) but nothing seems to work. How and where do I enter formatting for colour / font colour based on data that is already in the cell... and what do I need to type?
Also would it be faster to get Access to do this before I run a query - so that the formatting is appllied to the whole table or would it be faster to do it during the query process?
Any help would be much appreciated.
I want to change the color of the text in my table. it is blue and it is not so user friendly and I want it to be black. Need your attention .Thanks
View 2 Replies View RelatedI have this expression:
=IIf([Text131] Between 16 And 30,"Unacceptable",IIf([Text131] Between 31 And 42,"Marginal",IIf([Text131] Between 43 And 56,"Effective",IIf([Text131] Between 57 And 71,"Very Good",IIf([Text131] Between 72 And 80,"Outstanding","")))))
It works just fine, but I was wondering if there'd be a way to change the text color of the <<true>> statement based on what it is? i.e. "Outstanding" and "Very Good" would be green, "Effective" could be yellow, "Marginal could be brown and "Unacceptable" could be red. How would I implement that into this expression, if that's even possible? Thanx for your assistance!
Hi.
Is that even possible? I have form in datasheet view and text box on it. I need to change color of font in dependency of value of previous record.
Maybe some kind of conditional formatting? Can somebody help?
I'm trying to add some life to my form by using some different colors, but I can't figure out how to change the color of a button. Does anyone know how to do this? Thanks
View 7 Replies View RelatedQuick question here I hope.
I've got a little box covering up a drop down arrow on a combo control that resides on a tab control. The problem is that, since the Back Color property isn't available for a tab control, I have no idea what color it is...which is what the color of my box object (rectangle technically) needs to be so as to blend in. It looks a little garrish with it standing out there...
Any ideas what the default color of the tab page background is? Using Access 2003.
Thanks
-NR
Hi all,
Using Access 2003, WinXP SP2.
I have a form with the standard light grey background. I insert a tab control, and the default back color is white. I set the BackStyle to Transparent, and it still displays as white.
Am I missing something here, I want the back color of the tab control to be the same as my form.
Now, what's really odd, is in this project it creates tab controls as white, but if I open an old project of mine, it creates tab controls with the same light grey back ground of the form.
Any help?
TIA
Hammy
I did some searching on changing the color of a font if you change the data. I found a few posts but they really don't fit the need.
I am using a continuous form (which makes this even more difficult) and when someone changes data in a field I want that forecolor to change from black to red.
Is there an easy way (I know not everything is easy) :) in the conditional formatting to create an event? I am thinking not but thought I would ask.
My GUESS is that I need some sort of temp table to verify the data against then return with the forecolor change.
I am using A2k.
Thanks RichB
I have a Form with a List Box containing several options - with defined fore color (blue) and back color (white). However, when I click on an option to select it, the background color becomes black and the font color yellow (YUK!). How can I change this - ie. how can I select these colors? Thanks.
View 1 Replies View RelatedHi everyone.
I've searched the forum, couldn't find an answer. Is it possible to give each record in a continuous form a different backgroundcolor?
For example:
--------------------------------------------
Record 1 has a light yellow bgcolor
--------------------------------------------
Record 2 has a light blue bgcolor
--------------------------------------------
Record 3 has a light yellow bgcolor
--------------------------------------------
Record 4 has a light blue bgcolor
--------------------------------------------
And so on...
Thanks in advance!
Seth
I believe thats the proper word for it. Attached is a screenshot of a section of the database that I have started working on. It is to track placement for a college. Its my first ever and I am fairly good at making things look good, but as far as function - I am terrible.
I can change the raised box that the tab control sits on to a dark maroon when someone has a felony (so it notifies the user of this status)
Private Sub Form_Current()
If [Felony] = True Then
Felonybox.BackStyle = 1
Felonybox.BackColor = RGB(159, 19, 44)
Else
Felonybox.BackStyle = 1
Felonybox.BackColor = RGB(208, 207, 202)
End If
End Sub
I also have this done on After_Update.
I am trying to change the font on the Tab Control to Red when this occurs as well (only change the 'Criminal History CONFIDENTIAL' to red). I can not find this option anywhere, is this something that has been done or CAN be done?
Using A97
John D
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 Relatedhttp://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?
I have a CONTINUOUS form that shows all my records. I want it to change the back color of a field when it is a certain value. so far i get it to change back color when the very first record in the list is a certain value, but then it will change the back color for every value and not just one value.
can i fix this?