Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi all,

    Quick question (I suspect I will receive a negative response)

    Is it possible to Color Individual Cells (in a Column/Row) in a Form in Access 2007 when in DataSheet View using VBA.

    IE Just the Text or the Background?

    I can supply a couple of Thoughts if Needed.

    Graliv

  2. #2
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi Again,

    I've managed to adjust the Field I want to color to Memo in "rich text format" which Allows Text Selection and coloring: does anyone know the most Basic Formatting to color all text in the field RED via VBA??

    Tx Graliv

  3. #3
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts
    OK Sussed it just have to use HTML color etc IE <font color = "RED"

    Sorry for wasting anyones time, if they read this

    Thanks for helping me focus

    Graliv

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Is this truly the datasheet view, or is it a continuous form that looks like a datasheet? If it is truly a datasheet, then I believe it requires using 2007 to have that approach work. In any event, it is useful to have the post as someone else may be trying to do the same thing.
    Wendell

  5. #5
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Wikltshire UK
    Posts
    152
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by WendellB View Post
    Is this truly the datasheet view, or is it a continuous form that looks like a datasheet? If it is truly a datasheet, then I believe it requires using 2007 to have that approach work. In any event, it is useful to have the post as someone else may be trying to do the same thing.
    This is in a form, but it also works in the Table: IE if you set a Memo Field to Rich Text. You can use standard HTML Coding/Formatting. Wahay!! (and yes in Access 2007)

Posting Permissions

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