Color coding entries in a note field

[John Shaffer]

I am updating a LMS (Learning Managment System) I developed for my school. In the student note/comment field I would like to color code a entry ie; red for advirse, black for a normal and green for positve comments. the format for entries is MM/DD/YY comment and initials.

9/24/01 Shaffer sleeps in class JOS. (red)

9/24/01 Jones completed Mod 12 with a 75 JOS. (black)

9/24/01 Smith completed the course with a 96 avg. JOS (green)

I am setting up the LMS for FM Server 5.5, I will have about 121 Instructors using the LMS and 20 Adminstrative personel.

Thanks

John Shaffer

[SteveB]

If the above notes are all in one field, you are out of luck - Fm can't do it!

[Vaughan]

Consider changing the date format to yyyy/mm/dd because it sorts much, much better.

[dddane]

on the layout you're wanting this on... have 3 calculated fields...one that returns the value of the text that you want to be red... if you don't want something to be red return nothing... do the same for the other two colors... then on your layout format each of these calculated fields to be whatever color you want then them directly on top of each other... if the item was supposed to be red it'll come through on the field you formatted to be red and the other two will have blank results so you'll only see the red... and same for the other colors...