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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

format function

Status
Not open for further replies.
access23

access23

Technical User
Jul 25, 2003
8
0
0
US
Expr1: IIf([ST]="01","y",Format("n","[red]"))
Can anyone tell me why this is not work?
I want to change the "n" to red color
 
Sort by date Sort by votes
Format is used to change the formatting, but not color of the expression.

To change the color, tap into the OnFormat event of the report, and change the color of the Textbox there.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rudolfelizabeth
  • Locked
  • Question
day function in ms access doesn't return the day name and there isn't a function date name
Replies
3
Views
63
Andrzejek
Andrzejek
ptrifile
  • Locked
  • Question
Format of Date from Query 1
Replies
2
Views
36
ptrifile
ptrifile
PWD
  • Locked
  • Question
Access 2019 IIF + Public Function 1
Replies
5
Views
54
PWD
PWD
supportsvc
  • Locked
  • Question
Text to Format as Date? 1
Replies
5
Views
56
supportsvc
supportsvc
qqp
  • Locked
  • Question
Aggregate function error in query 1
Replies
11
Views
86
JordanSanders
JordanSanders

Part and Inventory Search

Sponsor

Back
Top