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

Conditional Formating

Status
Not open for further replies.
ccjjscb

ccjjscb

Technical User
Jan 18, 2006
29
US
Hello All,
I have a query that calculates dates and would like to format the date field fonts to be red if the date is less than todays date. Is there a way to make this happen in a query?
Thanks for any help
Chris
 
Sort by date Sort by votes
Make a report based on the query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
You can create a datasheet form with conditional formating on one of the fields/columns.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cimoli
  • Locked
  • Question
Need Conditional calculated query field to look at 3 real fields in the query. 1
Replies
3
Views
102
PHV
PHV
jnuus
  • Locked
  • Question
Hide Conditional Data 1
Replies
1
Views
122
PHV
PHV
Marco123
  • Locked
  • Question
Access SQL Conditional Join
Replies
4
Views
213
Marco123
Marco123
djugene188
  • Locked
  • Question
Conditional Order By 1
Replies
3
Views
115
djugene188
djugene188
jcfraun
  • Locked
  • Question
Conditional Formatting in Pivot Table view
Replies
0
Views
64
jcfraun
jcfraun

Part and Inventory Search

Sponsor

Back
Top