Highlighting

[DeniseP09]

I want to highlight all the discharge dates in my db but acess won't allow me
to do it for just certain records. One of my co-workers suggested I convert
my db from acess to excel.

My question: can I highlight certain records using acess or should I convert
my db to excel?

Thank you

 

[fredg]

I want to highlight all the discharge dates in my db but acess won't allow me
to do it for just certain records. One of my co-workers suggested I convert
my db from acess to excel.

My question: can I highlight certain records using acess or should I convert
my db to excel?

Thank you

How does Access (or we) know which record to highlight?
If you have Access 2000 or newer you can use Conditional Formatting in
the [DateField] control on Forms and Reports.

In Form/Report design view, select the control. Click on Format +
Conditional Formatting.
Then depending upon your criteria for determining the control's color,
set Condition1 to either "Has Focus", "Field Value Is", or "Expression
Is" and enter the value, or expression in the next dialog box.
(Note: if it is an expression, do NOT use the = sign.)
Select the color you wish. Save the changes.

Also, in Reports, depending upon the criteria to determine which
records to highlight on the page, you can use code.

 

[DeniseP09]

Hi Fred - I printed your instructions and I'll let you know how it turns out.

Thank you
--
Denise Perrelli
VNASCC Receptionist

I want to highlight all the discharge dates in my db but acess won't allow me
to do it for just certain records. One of my co-workers suggested I convert
my db from acess to excel.

My question: can I highlight certain records using acess or should I convert
my db to excel?

Thank you

How does Access (or we) know which record to highlight?
If you have Access 2000 or newer you can use Conditional Formatting in
the [DateField] control on Forms and Reports.

In Form/Report design view, select the control. Click on Format +
Conditional Formatting.
Then depending upon your criteria for determining the control's color,
set Condition1 to either "Has Focus", "Field Value Is", or "Expression
Is" and enter the value, or expression in the next dialog box.
(Note: if it is an expression, do NOT use the = sign.)
Select the color you wish. Save the changes.

Also, in Reports, depending upon the criteria to determine which
records to highlight on the page, you can use code.