Results 1 to 10 of 10
  1. #1
    AccessLes is offline Novice
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Posts
    15

    Conditional Formating for Field Before Group

    Hi,
    This is an example of my report

    Heading = Name Amount
    Detail = AA 10
    Detail = AA 20
    Group = 30

    Detail = BB 25
    Group = 25

    The group is on Name and the subtotal is on Amount.

    I would like to bold the detail for Amount only before the Group record. So for Name AA Detail Amount 20 is bolded. For Name BB detail amount 25 is bolded

    I think I need VBA code to do this. I don't think conditional formatting will work. Please let me know your thoughts.



    Accessles

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    I think you should try conditional formatting.
    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
    AccessLes is offline Novice
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Posts
    15
    Thank you for the response. However I don't know how to put a condition into the conditional response. Please show me how to accomplish this. Once I test it, I can mark the thread as Solved.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Access Help has guidelines on conditional formatting. Have you reviewed the step-by-step instructions and attempted? What is it you are specifically not understanding?
    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
    AccessLes is offline Novice
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Posts
    15
    Quote Originally Posted by June7 View Post
    Access Help has guidelines on conditional formatting. Have you reviewed the step-by-step instructions and attempted? What is it you are specifically not understanding?
    What I don't understand is how to bold the last record before the total for the group. If you look at the example it should help.

    I am using the forum to get help with my problem. I don't believe I am getting help with the responses I see. So please help me with my original request.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    What is the criteria? Because it is the last record or because it is 20? Why would you bold just because it is last record? Don't think will be simple.

    Why not just a separator line?
    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.

  7. #7
    AccessLes is offline Novice
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Posts
    15
    The criteria is the whenever the Name changes - the Amount on the last line for the Name needs to be bold. This is per my client's needs. I figured out an alternative. I put a field in the same table with another field tbl_bold. I used the conditional format for that field to turn on bold if that field is true. It works great.

    Thanks for all you help

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    So that is a Yes/No field? Won't that status change as records are added and burden the user with maintenance of this value? Are you able to automate populating/updating this value?
    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.

  9. #9
    AccessLes is offline Novice
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Posts
    15
    Quote Originally Posted by June7 View Post
    So that is a Yes/No field? Won't that status change as records are added and burden the user with maintenance of this value? Are you able to automate populating/updating this value?
    I am populating this field in vba. I am able to create the table with all the fields and then run a simple report. Hope that answers your question.

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Glad you found a solution to accommodate the client, no matter how bizarre the requirement. Clients - can't live with 'em, can't live without 'em!
    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.

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

Similar Threads

  1. Conditional Formating (Report Field)
    By mlawson6128 in forum Programming
    Replies: 1
    Last Post: 03-10-2011, 11:23 PM
  2. formating field
    By slimjen in forum Access
    Replies: 9
    Last Post: 01-11-2011, 04:46 PM
  3. Conditional calculated field.
    By ser01 in forum Queries
    Replies: 3
    Last Post: 01-03-2011, 02:16 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
  •  
Other Forums: Microsoft Office Forums