Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format Function in Access Report

Status
Not open for further replies.
dunner44

dunner44

MIS
Jul 27, 2004
32
US
In my report I want to set up a formula for a field so that if the value is greater than 1, then the font is red. I need help setting up the formula. Any suggestions?

Thank you!
 
Sort by date Sort by votes
Select the text box, and then click Format -> Conditional Formatting. Then just choose the appropriate options in the dialog box.

-Gary
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Question
Use 2 columns in Detail Section of report 1
Replies
8
Views
324
TrekBiker
TrekBiker
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
314
combo
combo
bhujanga
  • Locked
  • Question
Prevent Converstion of Long Numeric Strings to Exponential Format 1
Replies
4
Views
278
remeng
remeng
techie131
  • Locked
  • Question
Excel Date format
2
Replies
20
Views
604
SkipVought
S
arvarr
  • Locked
  • Question
Excel - getpivotdata function 2
Replies
3
Views
201
arvarr
arvarr

Part and Inventory Search

Sponsor

Back
Top