We have a database of names, addresses, dates, phone #'s, etc. I want the
report to italicize or color the names that have been entered in the last
month.

This is in Access

Do you have the date entered? You don't mention that.

If you do, use the conditional formatting in your forms and reports to color
the name field based on the value in the dateadded field.



--
Rick B



"Adrian" <(E-Mail Removed)> wrote in message
news:C12021D0-4E2D-4F18-A1F1-(E-Mail Removed)...
> We have a database of names, addresses, dates, phone #'s, etc. I want the
> report to italicize or color the names that have been entered in the last
> month.
>
> This is in Access
>

On Wed, 15 Feb 2006 09:17:28 -0800, Adrian
<(E-Mail Removed)> wrote:

>We have a database of names, addresses, dates, phone #'s, etc. I want the
>report to italicize or color the names that have been entered in the last
>month.
>
>This is in Access

You can create a Form or Report based on the table (or on a query
using the table); in that Form select Format... Conditional Formatting
on the textboxes that you would like highlighted. Use a condition of

[EntryDate] > DateAdd("m", -1, Date())

to choose which records to display differently.

John W. Vinson[MVP]

Thanks for the conditional formatting tip. I've been trying to do exactly
that for months. I've already included it in my database.
--
Jim Ory


"John Vinson" wrote:

> On Wed, 15 Feb 2006 09:17:28 -0800, Adrian
> <(E-Mail Removed)> wrote:
>
> >We have a database of names, addresses, dates, phone #'s, etc. I want the
> >report to italicize or color the names that have been entered in the last
> >month.
> >
> >This is in Access
>
> You can create a Form or Report based on the table (or on a query
> using the table); in that Form select Format... Conditional Formatting
> on the textboxes that you would like highlighted. Use a condition of
>
> [EntryDate] > DateAdd("m", -1, Date())
>
> to choose which records to display differently.
>
> John W. Vinson[MVP]
>