Formatting date field to bold

[OMS]

Hi,

I've been trying to get a field START_DATE to bold if it is todays date.
I've tried conditional formatting using Expression Is and Now() also tried
[START_DATE]=Now() and Format(Now(),"Short Date") to no avail. Using
Access2003. Control source is =(Trim(convDate(1,10,[START_DATE])) Original
format of START_DATE is "20080917" converted to "09/17/2008" for the report.

Any help you could provide would be most appreciated.

Thanks,
OMS

 

[Duane Hookom]

The Now() function contains the date and time. It will not equal the date
only except for a split second at midnight. The Date() function returns the
date part only. If the date field in your report's record source is text, you
may need to convert Date() to text.

 

[OMS]

I'm a bit confused by your last line. "If the date field in your report's
record source is text, you may need to convert Date() to text."
The field is a text field on the table. Did you mean convert Date() to
Date/Time when creating the table? I'm creating this table from several
other tables. I know I've done that before in the query but don't remember
how I did it. Can you refresh my memory or is that not what you meant?

Thanks,

The Now() function contains the date and time. It will not equal the date
only except for a split second at midnight. The Date() function returns
the
date part only. If the date field in your report's record source is text,
you
may need to convert Date() to text.

--
Duane Hookom
Microsoft Access MVP

Hi,

I've been trying to get a field START_DATE to bold if it is todays date.
I've tried conditional formatting using Expression Is and Now() also
tried
[START_DATE]=Now() and Format(Now(),"Short Date") to no avail. Using
Access2003. Control source is =(Trim(convDate(1,10,[START_DATE]))
Original
format of START_DATE is "20080917" converted to "09/17/2008" for the
report.

Any help you could provide would be most appreciated.

Thanks,
OMS

 

[OMS]

Duane,

What I did was use CDate(Trim(convDate(1,10,[START_DATE]))) in the query
changing the data type to Date/Time in the table. Then used
[START_DATE]=Date() in conditional formatting. Today's dates are now bold.

Thanks for your help,
OMS

I'm a bit confused by your last line. "If the date field in your report's
record source is text, you may need to convert Date() to text."
The field is a text field on the table. Did you mean convert Date() to
Date/Time when creating the table? I'm creating this table from several
other tables. I know I've done that before in the query but don't remember
how I did it. Can you refresh my memory or is that not what you meant?

Thanks,

The Now() function contains the date and time. It will not equal the date
only except for a split second at midnight. The Date() function returns
the
date part only. If the date field in your report's record source is text,
you
may need to convert Date() to text.

--
Duane Hookom
Microsoft Access MVP

Hi,

I've been trying to get a field START_DATE to bold if it is todays date.
I've tried conditional formatting using Expression Is and Now() also
tried
[START_DATE]=Now() and Format(Now(),"Short Date") to no avail. Using
Access2003. Control source is =(Trim(convDate(1,10,[START_DATE]))
Original
format of START_DATE is "20080917" converted to "09/17/2008" for the
report.

Any help you could provide would be most appreciated.

Thanks,
OMS