Modifying Format of Field Contents

[Tom]

Hello,

I have a form is Access 2000 (that is viewed in the datasheet view) where I
would like to have a particular field (a date field) turn Bold and Red if
the date is more than 15 days beyond today's date. Is this something that
can be done relatively easily?

[if date <(today-15),format bold red,)

Thank you.

 

[Fredg]

In Form Design View, click on the Date Field. Select Conditional formatting.
Set the Condition 1 drop-down to
Expression Is
Write
[DateField]< Date()-15
in the text box alongside the drop-down.

Select Bold and the color wanted.
Save the dialog.
Run the form.

 

[Tom]

Thank you! I should have known that ... Drain Bamage I guess

Thanks again!

In Form Design View, click on the Date Field. Select Conditional formatting.
Set the Condition 1 drop-down to
Expression Is
Write
[DateField]< Date()-15
in the text box alongside the drop-down.

Select Bold and the color wanted.
Save the dialog.
Run the form.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

Hello,

I have a form is Access 2000 (that is viewed in the datasheet view)

where

I
would like to have a particular field (a date field) turn Bold and Red if
the date is more than 15 days beyond today's date. Is this something that
can be done relatively easily?

[if date <(today-15),format bold red,)

Thank you.