batixan Posted November 21, 2010 Posted November 21, 2010 Hello to everyone, My question is if it is possible to format the text in the custom value list. For example to have the "10" in red, the "5" in green. Thank u.
Lee Smith Posted November 21, 2010 Posted November 21, 2010 You can not format the text in a custom value list. Lee
batixan Posted November 21, 2010 Author Posted November 21, 2010 Is there any other solution for that problem? I mean, I want to use some values in a formatted way. Is there any other way other than custom value list? Thanx
Lee Smith Posted November 21, 2010 Posted November 21, 2010 I think we need to know what you are trying to accomplish. In other words, under what conditions do you want to display what and why. You can use the Conditional Formatting on a field to show different text format based on the conditions you specify. Attach a file, or give a more complete description of what you have now, and what you want as an end result. Lee
batixan Posted November 22, 2010 Author Posted November 22, 2010 Thanx u for the immediate reply Mr. Lee I have a simple table with 3 fields. Field 1 is for date, field 2 is for worker's name and field 3 is the definition of work done by each worker. There is 4 types of work done ( difficult, easy, medium, and relaxed). My table is designed for records to show for each day who are working and which type of work they are doing. The things that I am wondering is if there is any way to format the difficult with red color, the medium with blue, the relaxed with green and the medium with light blue so that when I have the database viewed in browse mode to be easy distinguishable the type of work by colors rather than by text.
comment Posted November 22, 2010 Posted November 22, 2010 You can apply conditional formatting to the FIELD - this will show AFTER you make the selection from the value list. You cannot format the value list itself (i.e. you will not see colors WHILE you are making your selection).
Lee Smith Posted November 22, 2010 Posted November 22, 2010 It seems that comment agrees with me, I made a simple demo of what we were saying. HTH Lee batixan.fp7.zip
batixan Posted November 22, 2010 Author Posted November 22, 2010 You can apply conditional formatting to the FIELD - this will show AFTER you make the selection from the value list. You cannot format the value list itself (i.e. you will not see colors WHILE you are making your selection). Thank u very much. You were very helpfull.
batixan Posted November 22, 2010 Author Posted November 22, 2010 You can apply conditional formatting to the FIELD - this will show AFTER you make the selection from the value list. You cannot format the value list itself (i.e. you will not see colors WHILE you are making your selection). Thank u very much. You were very helpfull.
batixan Posted November 22, 2010 Author Posted November 22, 2010 It seems that comment agrees with me, I made a simple demo of what we were saying. HTH Lee Thank u too Mr. Lee. With your attachment you make me figure out the solution and apply it to my database.
batixan Posted November 22, 2010 Author Posted November 22, 2010 Here is my database after formatting according to your comments. The result is as I was want. Thank u a lot. EFHMERIES.zip
Recommended Posts
This topic is 5115 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