Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Font Colour based on UserID

Author  Topic 

DLTaylor
Posting Yak Master

136 Posts

Posted - 2007-02-05 : 05:53:24
We use an Access 2000 front end DB- with SQL 2000 security.

I would like to have data entered into a MEMO box on a FORM - where the colour of the text font is different for 3 specific users. Everyone else would remain in the standard black.
(When viewing the data in the form this would allow the reader to know who wrote what notes)

Is there a way to achieve this?
Thanks.

PurpleSun
Yak Posting Veteran

50 Posts

Posted - 2007-02-08 : 15:30:00
Don't play with colors, it's very annoying for the users.
Instead, put the name of the user who wrote the note as a note header, ie:
"John Doe:
Hello world"
Go to Top of Page
   

- Advertisement -