highlighting specific records

  • Thread starter Thread starter sesmock
  • Start date Start date
S

sesmock

I have a table that lists employees by their hire date. Is there a way to
highlight only the employees who have worked for less than one year? There
is a form that uses the list from a drop-down box. I would like to be able
to see those employees highlighted in a different color when they are
selected.
 
Are you trying to do this directly in the table? If so, stop now! Access
tables are NOT spreadsheets.

Have you looked into using a query to return only those in which you are
interested?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
In a form you could use Conditional Formatting. This won't work for a table
or query though.
 
I have a table that lists employees by their hire date. Is there a way to
highlight only the employees who have worked for less than one year? There
is a form that uses the list from a drop-down box. I would like to be able
to see those employees highlighted in a different color when they are
selected.
Click to expand...

You can't colorcode individual rows of a combo box, but you can use
Conditional Formatting to display individual rows of a continuous form in
different colors. Select the combo box (or other control) in form design view
and click the Format menu item, and choose Conditional Formatting.
 
I haven't changed anything in the table itself. What happens now is that I
run a query based on a particular day. It shows me all employees that have
used vacation on that day. I would like to have those within their first
year stand out some how from the rest of the employees in the query. Is this
possible?
 
I don't believe queries have that kind of conditional formatting available.

Would it be sufficient to alter your query to show folks who used vacation
on that day AND who's hire date is less than one year ago?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
I haven't changed anything in the table itself. What happens now is that I
run a query based on a particular day. It shows me all employees that have
used vacation on that day. I would like to have those within their first
year stand out some how from the rest of the employees in the query. Is this
possible?
Click to expand...

Sure.

Use a Continuous Form (not a query datasheet) based on the query, and use
Conditional Formatting *on the Form*.

Forms have a rich display environment. Table and query datasheets don't. Use
the right tool for the job... a Form.
 
Back
Top