i need some help please.I'm new to access,my question is how can i change the font colour for a yes/no field.Yes has to be in blue and no has to be in green in the same field. i know format is needed but lack the exp it hasnt worked yet
-
-
What version of Access are you in? You will find in the toolbox something called Conditional Formatting. You can apply conditional formatting to that object so that different values have different colors.
One problem, however is that you may be using a checkbox for this yes/no field, and I don't believe c/f is available for that. In that case you'll probably need some VB code to accomplish the task, and you'll have to settle for changing the color of the label beside the checkbox.
Let us know what your situation is.
Jim
Comment