Report Field Formatting - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Report Field Formatting

Musoke Herbert

3 years ago

Hullo Friends, i would like to know how i can do Conditional formating in Report field, for example i have a grading system if 80 - 10 (Color green) , 60 - 79 (Color Blue) , 50 - 59 (Color yellow) , 40 - 49 (color orange) , 0 - 39 (Color red)

	Kevin Robertson @Reply 3 years ago
Conditional Formatting in a Report is exactly the same as in a Form. Conditional Formatting

	Kevin Robertson @Reply 3 years ago

	Musoke Herbert OP @Reply 3 years ago
Thanks Kevin for the Support, am looking at Changing the Color of the Field not the Value Basing on the Value Scored, try it that way and see how the Field Color Can change, Thanks

	Kevin Robertson @Reply 3 years ago
Just set the Backcolor instead of the Forecolor.

	Musoke Herbert OP @Reply 3 years ago

	Musoke Herbert OP @Reply 3 years ago
That is the Report am looking at formatting the field basing on the score but not the Field value

	Musoke Herbert OP @Reply 3 years ago
Sure my challenge is how to set the Back color because when i get to conditional formatting there seem to be no option for setting the back color

	Kevin Robertson @Reply 3 years ago

	Musoke Herbert OP @Reply 3 years ago
Thanks alot Kevin, i realised that i had made the field transparent and Now it works , Thanks alot

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View