Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Question on Properties in a Form?? 1
- Thread starter quest4
- Start date
-
1
- #2
Quick answer: nope, can't do it.
Long answer: How badly do you need it? From experience, I've found that it just isn't worth the headache of trying to get it to work. Here is a link to a database that someone wrote to demonstrate this trick. It didn't work on my computer, but some other programmers here have said it works on theirs. Maq B-)
<insert witty signature here>
Long answer: How badly do you need it? From experience, I've found that it just isn't worth the headache of trying to get it to work. Here is a link to a database that someone wrote to demonstrate this trick. It didn't work on my computer, but some other programmers here have said it works on theirs. Maq B-)
<insert witty signature here>
- Thread starter
- #3
gusbrunston
Programmer
Hi...
What's the problem?
Why can't you go to the property sheet for each text box and set the fore color to whatever you like? I do it all the time. (Access2000)
Gus Brunston
An old PICKer
padregus@home.com
What's the problem?
Why can't you go to the property sheet for each text box and set the fore color to whatever you like? I do it all the time. (Access2000)
Gus BrunstonAn old PICKer
padregus@home.com
gusbrunston
Programmer
Ok...
Maybe I misunderstood. Did you mean "Can you set the fore color individually for each record?" You can certainly change the fore color of each text box as I said. But looking at the page suggested by Maquis, I see that you may not want just to change the fore color for each text box, but you may want different fore colors for different records.
I have a subform that displays transactions like a check register. Abutting all the text boxes (i.e., they are cotangent) I change the back color for all the records for each month, depending on whether the month number is odd or even. You can format the fore color (or back color) "conditionally" based on something like odd or even primary keys (autonumber, or ?), which would give you alternating blue and beige, or whatever, like QuickBooks.
Hope this helps, or if I don't understand the question, maybe I need the help! Gus Brunston
An old PICKer
padregus@home.com
Maybe I misunderstood. Did you mean "Can you set the fore color individually for each record?" You can certainly change the fore color of each text box as I said. But looking at the page suggested by Maquis, I see that you may not want just to change the fore color for each text box, but you may want different fore colors for different records.
I have a subform that displays transactions like a check register. Abutting all the text boxes (i.e., they are cotangent) I change the back color for all the records for each month, depending on whether the month number is odd or even. You can format the fore color (or back color) "conditionally" based on something like odd or even primary keys (autonumber, or ?), which would give you alternating blue and beige, or whatever, like QuickBooks.
Hope this helps, or if I don't understand the question, maybe I need the help! Gus Brunston
An old PICKer
padregus@home.com
gusbrunston
Programmer
Replace "cotangent" with "contiguous"! Arggh! :~/ Gus Brunston
An old PICKer
padregus@home.com
An old PICKer
padregus@home.com
- Thread starter
- #7
gusbrunston, Thanks for the response. Bassically we are just trying to change the color of the text, which is ForeColor, when a certain reason comes up. This is purely cosmetic, making it easier to spot employees who missed work. We have already brought down the database and are startingto play with it. Thanks again for the response.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question