Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2007
    Posts
    4

    Red face Unanswered: Access 97 - Report Question

    Help, I have a report containing data (dates, details, comments, etc.) that also telling me whether obligations are "On Plan" or "Complete" for those items that are "complete" is there anyone I can gray out those items, either background or font, and leaving only the items that are "On Plan" in plain black text?

    thank you...

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Look at the Conditional Formatting for that field. You can set the font/background dependant on the values in the field.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Nov 2007
    Posts
    4
    I read on several post that A97 does not have conditional formatting...

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    It's been a while since I've used 97 but if you select Format -> Conditional Formatting, I think you'll see it in 97. Let us know though as I'm curious.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  5. #5
    Join Date
    Nov 2007
    Posts
    4
    Paul,
    My friend recommended the same thing and the option is not there, I appreciate your help...for the amount of work we do in access I would think my corporation would allow for an upgrade.

  6. #6
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    hmmm.....interesting. I thought for sure Access 97 had the conditional formatting.

    Otherwise, you can always go the coding route and put in some code like in the OnFormat event of the detail section of the report:

    Select Case me!MyField
    Case "Something"
    me.MyField.BackColor = 255
    me.MyField.FontName = Something
    me.MyField.FontSize = Something
    me.MyField.ForeColor = 1234
    Case "SomethingElse"
    me.MyField.BackColor = 0
    me.MyField.FontName = Something
    me.MyField.FontSize = Something
    me.MyField.ForeColor = 234
    end select
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  7. #7
    Join Date
    Nov 2007
    Posts
    4
    thanks Paul, I will try.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •