• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • 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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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