Results 1 to 2 of 2
  1. #1
    zhshqzyc is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    9

    Mark the difference

    Hello, I just import an excel to create a table. Now I want to create a form or report to display it. I want to mark the difference between the rows. It means that if there is difference then a color is marked on the cells.


    For ex,
    610_1 C T T G T T G
    610_2 C T T G F T G
    For group 610, in the experiment 1 and 2, all cells are same except "T" and "F". So I marked them with red color.

    Thanks for help.

  2. #2
    Rixxe is offline Blessed Bear
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Location
    London (Essex ... yep!)
    Posts
    184
    Depending on how many different things you want to compare, it might be worth looking into 'IF' and 'Else'.

    None the less here is something that i found from the internet (After a few seconds) which might help get you started.

    Code:
    compareResult = strcomp(string1, string2, False, CultureInfo.InvariantCulture)
    Above is how to compare the strings...

    And this site is how to change the colours of parts of a string...
    http://vbadud.blogspot.com/2007/09/e...r-part-of.html

    I'm sure someone here can help you combine them if you get stuck.

    Good Luck

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to mark a thread as solved
    By Matrix in forum Forum Suggestions
    Replies: 10
    Last Post: 12-12-2019, 06:55 AM
  2. How to make a Water Mark
    By newtoAccess in forum Reports
    Replies: 7
    Last Post: 12-06-2010, 04:13 PM
  3. Mark invoice paid
    By kylebmorris in forum Reports
    Replies: 1
    Last Post: 07-19-2010, 12:39 PM
  4. difference between drivers
    By tomc1 in forum Access
    Replies: 0
    Last Post: 08-04-2009, 10:41 AM
  5. Time difference
    By jguidry in forum Programming
    Replies: 1
    Last Post: 11-15-2008, 12:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums