Results 1 to 3 of 3
  1. 12-15-2009, 04:05 AM #1
    Merkava
    Merkava is offline Novice
    Windows XP Access 2002
    Join Date
    Nov 2009
    Posts
    20

    Colouring Fields

    Hello All,

    I have a report built with the wizard, there will some listings where the textbox will be empty. Is there any way to set the background colour on the condition that textbox is empty

    Regards,
    Aaron
    Reply With Quote Reply With Quote
  2. 01-14-2010, 04:18 PM #2
    llkhoutx
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    On the report's Detail section OnFormat event, test the fields value and appropriately set that fields backcolor property.
    Reply With Quote Reply With Quote
  3. 01-14-2010, 05:47 PM #3
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I think it would be easier to just use ConditionalFormatting for the control.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Table fields which depend on other fields
    By Ben in forum Access
    Replies: 3
    Last Post: 08-10-2009, 08:33 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums