edit text box with new format

[vicsaccess]

i have a request for work form that a supervisor views all requested work and either approves or denies the request to proceed further into the planning phase. my curiousity is if this supervisor denies the work i would like to know why it was denied if i go back thru old records. can i have a text box formatted with black during the request phase and if the supervisor wants to denie the work his notes to that field are added in a differant color like red?

[June7]

What identifies a record as 'approved' or 'denied'? There is a field for this flag?

The notes field can have back color or font color dependent on value in the status field. Use Conditional Formatting.

Textbox and combobox have Conditional Formatting available.

[vicsaccess]

thanks June, yes there is a field for approved or denied but if i use conditional formatting won't that affect the entire entry in the text box. don't think i was clear on the first post. this is a message box that the individual puts notes about the requested repair. my curiousity was that if the supervisor could use that same text box but his entry would be red instead of black. that way we could look back thru old entries and distinguish at what phase of the request the parts of the message came from. my other option that came to mind was a separate text box for the supervisor to put his notes but i would like to avoid that if possible.

[June7]

Access has very limited text formatting capability. What you want would require Rich Text Formatting. A memo field in table would have to be set as RTF and then textbox with corresponding setting which will enable RTF tool bar. User can apply RTF formatting to text. Basically, this embeds HTML code tags into the text string.

Your arrangement that allows multiple notes input to same field is not a normalized data structure.

[vicsaccess]

understand June, sounds like for data storage space alone i would be better off giving the supervisor a seperate text/memo box and maybe limiting the number of characters. was hoping for a easy color designation. thanks