Results 1 to 6 of 6
  1. #1
    vicsaccess's Avatar
    vicsaccess is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Apr 2015
    Posts
    451

    back color based on value in split form


    is it possible in a split form to have the value of txtgo be different colors based on the value? 1 would be green, 2 would be yellow and 3 would be yellow. I know how to do it in a single form but not a split or continuous form.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Use Conditional Formatting properties, not VBA.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    vicsaccess's Avatar
    vicsaccess is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Apr 2015
    Posts
    451
    that works on a split form? I gave it a shot earlier but didn't think it would work so I moved on. i'll try again, any tricks? if looking for not null?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Yes, it works on split form.

    Not sure what you mean by 'if looking for not null'. No IIf() is involved.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    vicsaccess's Avatar
    vicsaccess is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Apr 2015
    Posts
    451
    thanks june7

  6. #6
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Quote Originally Posted by vicsaccess View Post
    ...that (Conditional Formatting) works on a split form...
    FYI, Conditional Formatting works on any type of Form! But it is the only way to do this type of Formatting on a Datasheet View or Continuous View Form. And since a Split Form involves a Datasheet View...you have to use Conditional Formatting for this.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Conditional back color of box.
    By BatmanMR287 in forum Reports
    Replies: 3
    Last Post: 07-12-2015, 02:39 PM
  2. Alternate Back Color Property
    By RayMilhon in forum Reports
    Replies: 5
    Last Post: 11-15-2012, 06:20 PM
  3. Form Back Color, screen only?
    By LostInAccess in forum Forms
    Replies: 2
    Last Post: 07-19-2012, 08:39 PM
  4. Report Back Color formatting
    By RayMilhon in forum Reports
    Replies: 5
    Last Post: 02-07-2012, 03:20 PM
  5. Back color update issue
    By GraemeG in forum Programming
    Replies: 3
    Last Post: 03-21-2011, 11:32 AM

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