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 RepliesHi 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
Is it possible, and if so, how, to change the colors of the background area where the navigation bar is?
(Area marked within included image)
I have a form which uses a query for entry to the table. One of the fields in the query is a calculated field which shows in the form. The calculated field returns a number from 1 to 5. Rather than showing this number I would like to show a round stoplight that changes color for each number. I have inserted a OLE object OLEunbound235 into the form. The colors I want to use are
icolor = RGB(255, 204, 0) 'Gold
icolor = RGB(192, 192, 192) 'Silver
icolor = RGB(216, 129, 0) 'Bronze
icolor = RGB(255, 255, 0) 'Yellow
icolor = RGB(255, 0, 0) 'Red
and icolor = RGB(255, 255, 255) 'White for any other value.
The text box that returns the calculated number is labeled Text1 and I have hidden this box so it can not be seen. Does anyone know how to write this code that would change the OLE object color automatically so when the user enters data into the form and the return number changes the color of the OLE object changes. I know very little about VBA and I am not sure where to begin or where to even write the code.
:confused:
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.
I have a form that displays inventory using a datasheet format..
is there a way that i can make it so that if that record has a sales order number (because it is sold) then highlight that record...
All I want to do is change the font color and weight of a couple of columns in a form. No conditions or change when button is pressed or anything like that. Just be blue and stay blue.
I've tried making it a memo, rich-text field and it didn't work.
It works fine in the "member details" form, but not the "member list" form.
Member Details:
Member List:
Hello,
Does anyone know how to color alternate rows in two different colors in a continuous form?
:(
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 RelatedHi
I am running Access 97 and I was wondering if it was possible to change the colour(background or text) of a single record based on an attribute
I was hoping that my subform viewing all of the records (datasheet) would look like this based on Task Des column
eg Condition = red, Awaiting = Blue
(Below is ment to look like an access datasheet view)
Property No | Task Des | MCU/ROL
PN1234/DA1 | Condtion | MCU
PN1235/DA2 | Condtion | ROL
PN1994/DA1 | Awaiting | MCU
I have read you can do this quiet easy in access 2007 but was wondering if possible in 97
Thanks heaps for your help
Thanks
I have a form that contains a toggle button. When a record is complete and considered closed I click the toggle button. I want to make the form background turn red if I enter into a record that has been closed. :confused:
If this is not possible, is there something similiar that would stand out:rolleyes:
Can someone tell me how to do this? Thanks!
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?
Is it possible to have a field (Color) on a form be set to a combo box. A drop-down box appears with Green, Red, Blue, Yellow, Other. When other is selected a dialog box prompt appears asking the user to enter the color. The response is then what appears in the Color field.
View 1 Replies View RelatedIn Access 2007 (or 2010 , 2013), in a continuous form, I want to change the background colour of a text box depending on its value. Obviously, for each record, the color can be different.
View 1 Replies View RelatedI have a continuous form based on a orders table and a details sub form.I list all the records in a continuos form in date of order.i need to change the colour of a single record based on the condition of a tick box on the original orders form
View 1 Replies View RelatedI would like to be able to change font color and appearance while entering data into a form (example: italicize a word). Is there any way to activate the font format while in a form?
View 2 Replies View Relatedin 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 RelatedI have a new staff member in my office that has informed me that she has a degree of dyslexia. To assist her I've trialled changing the textboxes on one form in my Access 2013 application to a light pink color & this has instantly worked for her to read/input text.
Is there a way to automatically change each textbox to light pink on every form in my application on startup based on user login (say using an IIF statement in the OnLoad event of the startup form).
I have a Form Display Data in my Access Database, which is working really well. However, users was asking if there is a way we can make Font Color Could/would change if The text in A field or Any field in my display form contained the word "SAD or MAD". Is there code for such thing in display form?..
View 3 Replies View Relatedhi 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