Results 1 to 3 of 3

Formatting in a Report

  1. #1
    MidoriiBlue is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    1

    Question Formatting in a Report

    I have an access report that pulls data from an outside database.
    Instead of using labels (because its hard to line them up properly) with the text box fields I have created an expression to include the label I need inside - For example: ="Name: " & [CONTACT_NAME]
    Is there a way to use the conditional formatting to change the font color of just "Name" or just the data [CONTACT_NAME] or will it always apply to the whole field?

    Thanks for any help!

  2. #2
    June7's Avatar
    June7 is offline Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    28,084
    Applies to the whole field.

    Review this http://office.microsoft.com/en-us/ac...010014097.aspx
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    RayMilhon is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    718
    I'm curious as to why you think they're hard to line up?

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

Similar Threads

  1. formatting a report?
    By mejia.j88 in forum Reports
    Replies: 1
    Last Post: 01-13-2012, 01:20 PM
  2. formatting the report
    By simba in forum Reports
    Replies: 1
    Last Post: 08-12-2011, 11:36 AM
  3. #Name? Conditional Formatting Report
    By stosh59 in forum Reports
    Replies: 5
    Last Post: 01-10-2011, 12:40 PM
  4. Conditional formatting in report
    By RickM in forum Access
    Replies: 1
    Last Post: 09-10-2009, 05:21 PM
  5. Lost report formatting
    By kiltedcueball in forum Database Design
    Replies: 2
    Last Post: 06-22-2009, 11:28 PM

Tags for this Thread

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