mleiser Posted June 18, 2012 Share Posted June 18, 2012 Hi. I have no clue on this one. I have a table that, based on a code, gives the name of a color. When bringing in the name of the color into my related database, I want the text (red, blue, etc) to be its color. So if the code brings back the word "red" I want it to be in red or at least have the shading or something in that color. Any help here? Thanks. Mike Link to comment Share on other sites More sharing options...
comment Posted June 18, 2012 Share Posted June 18, 2012 How many colors are there? Link to comment Share on other sites More sharing options...
mleiser Posted June 18, 2012 Author Share Posted June 18, 2012 About six. Basically, we have a school. For the younger grades, depending on their bus stop (code) we place a sticker on a button and color in the bus color so they know where they're going. I set up a table that, based on the code, gives the bus color to each student. I want the color name to be in its color. Does this make sense? Link to comment Share on other sites More sharing options...
mr_vodka Posted June 18, 2012 Share Posted June 18, 2012 If I understand correctly, you should just be able to put a conditional format on the field itself that checks for multiple conditions. Such as: Self = "Red" Self = "Yellow" Self = "Green" Self = "Orange" Self = "Purple" Self = "Brown" Just choose whatever gradient you want for each text color. Link to comment Share on other sites More sharing options...
mleiser Posted June 19, 2012 Author Share Posted June 19, 2012 Guess I'm a bit ignorant on this. Can you be a little more detailed? Thanks so much. (I'm just starting to change over to 12) Link to comment Share on other sites More sharing options...
eos Posted June 19, 2012 Share Posted June 19, 2012 Set up Conditional Formatting for the field like in the screenshot. Choose a different text color for each condition. Order is irrelevant, since all conditions are mutually exclusive. If you want to format another field based on your color field, replace Self with the name of the color field. Link to comment Share on other sites More sharing options...
mleiser Posted June 19, 2012 Author Share Posted June 19, 2012 Thanks a million. I'll try it. Link to comment Share on other sites More sharing options...
mleiser Posted June 25, 2012 Author Share Posted June 25, 2012 Hi. That last idea worked out great. Thanks. I have another conditional formatting type question. I have a report with one line per record with, say, 10 fields. Suppose I want to show 10 fields per line on most of the reports but only 8 of those fileds if x=y. I could always make two identical reports, one with all 10 fileds and one with two fileds set not to print. I would think there would be an easier way with just one layout? Mike Link to comment Share on other sites More sharing options...
eos Posted June 25, 2012 Share Posted June 25, 2012 You could use CF to make the field contents invisible, e.g. by setting a very large font size (like, 500), which works regardless of the background color. On the other hand, depending on the field arrangement, this might leave visible gaps, so maybe making two dedicated and optimized layouts is the better solution. Link to comment Share on other sites More sharing options...
Lee Smith Posted June 25, 2012 Share Posted June 25, 2012 .. want to show 10 fields per line on most of the reports but only 8 of those fileds if x=y What does the x=y represent? Link to comment Share on other sites More sharing options...
hbrendel Posted June 25, 2012 Share Posted June 25, 2012 What does the x=y represent? It's not interesting. It's the outcome: true (1) or false (0) Link to comment Share on other sites More sharing options...
Lee Smith Posted June 25, 2012 Share Posted June 25, 2012 It might be better served through access privileges if it a security issue! Link to comment Share on other sites More sharing options...
hbrendel Posted June 25, 2012 Share Posted June 25, 2012 You have a point. Link to comment Share on other sites More sharing options...
mleiser Posted June 26, 2012 Author Share Posted June 26, 2012 The x=y I said just to mean a condition. Like if it's for the office staff I might leave the fileds on the report. If it's for teachers I might want to leave off some fileds. I guess I may have to go with the two layouts. thanks Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4330 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now