By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

FLAGGING SYSTEM

P: n/a
Hope someone out there can help.

I have created a database which holds clients information of
assessments they have had. I have also created a simple query which
will let me know that that person is due another assessment in 2
months time:

Month(DateAdd("m",2,Date()))

However, I would also like the query to tell me people due in 3 months
time but place there data in another colour, i.e., red. Is this
possible?

Many thanks to anyone who can help

stu
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
You didn't indicate what version of Access you're using, but if it's Access
2000 or greater look into Conditional Formatting ... this allows you to set
certain colors and such of your form controls dependant on the
value/conditions of the underlying data.

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
"Stuart Masters" <st************@pcs-tr.swest.nhs.uk> wrote in message
news:60**************************@posting.google.c om...
Hope someone out there can help.

I have created a database which holds clients information of
assessments they have had. I have also created a simple query which
will let me know that that person is due another assessment in 2
months time:

Month(DateAdd("m",2,Date()))

However, I would also like the query to tell me people due in 3 months
time but place there data in another colour, i.e., red. Is this
possible?

Many thanks to anyone who can help

stu

Nov 12 '05 #2

P: n/a
Sorry

I'm using Access 97
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

P: n/a

On 16 Jan 2004 13:49:24 GMT, Stuart Masters
<st************@pcs-tr.swest.nhs.uk> wrote in
comp.databases.ms-access:
I'm using Access 97


To change the color of a column in Access 97 queries, just select the
column in the query designer and right click and choose properties,
then on the 'General' tab of the popup properties dialog, under
'Format', type

[color]X

where 'color' is the desired color and 'X' is the desired format. So,
if dates are being displayed, and you wanted the query to display
green text, you could type

[green]m/d/yy

for example.

This formats the entire column in the selected color. To format just
certain values, you could, for instance, set a flag column with a
calculated field (something along the lines of

isOverdue: [DueDate]<now()

then in the format field, use something like

"Ok";[red]"Late!"

This would flag, in red, the overdue rows, and leave the non-overdue
rows in black.

You get the picture.

Scott mentioned conditional formatting in forms in Access 200 and
later, but the conditional color formatting works in earlier versions
too, and works for queries directly, and not just forms/reports.
Peter Miller
__________________________________________________ __________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results
www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.