Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Two-color Data Within a Memo Text Box (2000)

    Me and one of my colleagues at work type data into a text box on a form whose control source is a memo-type field. The mdb file containing the form is located on a shared network drive so each of us accesses the file from one's own computer.
    I'd like the information typed in by my colleague to show differently from mine so is there any way to make Access input characters with two different colors dependent on who's typing it?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Two-color Data Within a Memo Text Box (2000)

    Questions like this come up frequently. The answer is always the same: Access doesn't provide this capability. A text box has but a single format that is applied to *all* text.

    The Microsoft Rich Text box control (an ActiveX control) can display formatted text, but since it is not a native Access control, you'll have to do all the work yourself in code. I don't think it's worth the hassle, but that's my personal opinion.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Two-color Data Within a Memo Text Box (2000)

    Is there any way that I can make the Microsoft Rich Text box control discern among data typed in using different pc's and so format it differently?

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Two-color Data Within a Memo Text Box (2000)

    As Hans said, you can't have different colors within a text control. Given your situation, perhaps a change in your database structure would be a better solution. Rather than typing into a single memo field, you should create another table that is on the "many" side of a one-to-many relationship with the table containing the text field. This new table would essentially be a Comments table. Each record would contain fields for EntryDate, WrittenBy, and the Comment itself.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •