Modifying Format of Field Contents

  • Thread starter Thread starter Tom
  • Start date Start date
T

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.
 
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.
 
Thank you! I should have known that ... Drain Bamage I guess

Thanks again!

Fredg said:
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.


Tom said:
Hello,

I have a form is Access 2000 (that is viewed in the datasheet view)
Click to expand...
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.
Click to expand...
Click to expand...
 
Back
Top