Results 1 to 3 of 3

Conditional Formating help

  1. #1
    Mounds is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2011
    Posts
    22

    Conditional Formating help


    I am not sure on how to do this but I believe it can be done easily. I have 2 forms a and b. On "a" there is a check box. On "b" I have order numbers in a text box. I would like to make it so that when the check mark is checked on "a" it makes the background for the order number text box to be red or yellow in form "b"
    It seems simple enough, but I'm not sure how to do this one.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,898
    Perhaps this link will be helpful: http://access.mvps.org/access/forms/frm0031.htm
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    Mounds is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2011
    Posts
    22
    Well kinda, I'm not super good with code. But it is 2 forms not a form with a sub form. Should I use one of these to update the other form, then use that form to run the conditional formatting.

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

Similar Threads

  1. Conditional formating!
    By karanvemuri in forum Access
    Replies: 3
    Last Post: 10-29-2011, 03:34 PM
  2. HELP! Conditional Formating question
    By tobydobo in forum Access
    Replies: 1
    Last Post: 09-09-2011, 04:14 PM
  3. Conditional Formating (Report Field)
    By mlawson6128 in forum Programming
    Replies: 1
    Last Post: 03-10-2011, 11:23 PM
  4. Conditional Formating In A Report
    By cadsvc in forum Reports
    Replies: 11
    Last Post: 11-02-2010, 04:47 PM
  5. Conditional Formating in pivot table
    By Tina in forum Access
    Replies: 0
    Last Post: 08-25-2010, 10:38 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
  •  
Tech Forums: Microsoft Office Forums