Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

Acess Report - compare two fields and if they are different, change the formatting of one of the fields

I have a report which has a few amounts in each record.  I would like to compare the amounts and if they are different, the 2nd field should change to be italicized.

How do I do this?

Thanks.
0
YLaw
Asked:
YLaw
  • 4
  • 3
1 Solution
 
rockiroadsCommented:
have u tried conditional formatting?

0
 
peter57rCommented:
Hi YLaw,
Use conditional formatting on the textbox you want to change.(Right click>Conditional Formatting)
Pete
0
 
rockiroadsCommented:
alternative is this

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

    If Amount1 > Amount2 Then
        Amount1.FontItalic = True
    Else
        Amount.FontItalic = False
    End If
End Sub
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
rockiroadsCommented:
typo in my last post, but Im sure you catch the drift
0
 
YLawAuthor Commented:
rockiroads,

I've never used conditional formatting.  Which one would be better.  That or the detail_format?
0
 
rockiroadsCommented:
well the detail_format is easier if you don't know conditional formatting

But its always good to learn
when u go into conditional formatting (either click on control, then go to Format/Conditional formatting or right click/Conditional Formatting)

u select your conditon

Field Value is

2nd combo is greater than

and so on


0
 
YLawAuthor Commented:
sorry not to sound really dumb...I can't find where it says conditionally formatting (Sorry it's taken so long to get back to you)
0
 
YLawAuthor Commented:
whoops...I thought you meant the control's format tab...I got it.  Great. thanks.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now