Highlight expired time sensitive information

[Guest]

Good Morning,

I have a side project (which is helping me learn for my massive main
project), which has time sensitive data stored on a table. Is it possible to
Highlight the record (I have already created a form for users to view the
data on a sub form), when a period of x amount of time has passed since the
record was added? Whether this be the text or cell highlighted i don't mind,
but it is only necessary to view in the subform.

Thanks in advance

Dave

 

[Guest]

I can't see why not. I would have thought an "if" statement would work using
the difference between today and the record date something like (off the top
of my head):

if date() - [field] > 5 then fieldname.forecolor = 000000

 

[Guest]

Thanks. I'm getting an error message saying "The expression you entered
contains invalid syntax. You may have entered an operand without an operator"
It highlights "then" in between 5 and fieldname.forecolor = 000000

I can't see why not. I would have thought an "if" statement would work using
the difference between today and the record date something like (off the top
of my head):

if date() - [field] > 5 then fieldname.forecolor = 000000


--
www.ae911truth.org

Good Morning,

I have a side project (which is helping me learn for my massive main
project), which has time sensitive data stored on a table. Is it possible to
Highlight the record (I have already created a form for users to view the
data on a sub form), when a period of x amount of time has passed since the
record was added? Whether this be the text or cell highlighted i don't mind,
but it is only necessary to view in the subform.

Thanks in advance

Dave

 

[Guest]

This works:

add an extra read-only field and put in the control source:

=Date() - [Field]

where "field" is your date.

That will give you the difference in days.

Go to format -> Conditional formatting.

Then you change the formatting to highlight the field. As far as the whole
record is concerned I am not sure but it depends whether your form is
continuous or not.

--
www.ae911truth.org

Thanks. I'm getting an error message saying "The expression you entered
contains invalid syntax. You may have entered an operand without an operator"
It highlights "then" in between 5 and fieldname.forecolor = 000000

I can't see why not. I would have thought an "if" statement would work using
the difference between today and the record date something like (off the top
of my head):

if date() - [field] > 5 then fieldname.forecolor = 000000


--
www.ae911truth.org

Good Morning,

I have a side project (which is helping me learn for my massive main
project), which has time sensitive data stored on a table. Is it possible to
Highlight the record (I have already created a form for users to view the
data on a sub form), when a period of x amount of time has passed since the
record was added? Whether this be the text or cell highlighted i don't mind,
but it is only necessary to view in the subform.

Thanks in advance

Dave

 

[Guest]

Thanks for your continued support. I think i'm nearly there but i don't know
how to write the conditional format. I assumed it would be;

Field Value is > Greater Then Or Equal To > 5

As in 5 days. I have entered test data and the field changes colour but
instead of a number just says #Name?

A really appreciate your help

This works:

add an extra read-only field and put in the control source:

=Date() - [Field]

where "field" is your date.

That will give you the difference in days.

Go to format -> Conditional formatting.

Then you change the formatting to highlight the field. As far as the whole
record is concerned I am not sure but it depends whether your form is
continuous or not.

--
www.ae911truth.org

Thanks. I'm getting an error message saying "The expression you entered
contains invalid syntax. You may have entered an operand without an operator"
It highlights "then" in between 5 and fieldname.forecolor = 000000

I can't see why not. I would have thought an "if" statement would work using
the difference between today and the record date something like (off the top
of my head):

if date() - [field] > 5 then fieldname.forecolor = 000000


--
www.ae911truth.org



:

Good Morning,

I have a side project (which is helping me learn for my massive main
project), which has time sensitive data stored on a table. Is it possible to
Highlight the record (I have already created a form for users to view the
data on a sub form), when a period of x amount of time has passed since the
record was added? Whether this be the text or cell highlighted i don't mind,
but it is only necessary to view in the subform.

Thanks in advance

Dave

 

[Guest]

In design view click on the field. Go to the format menu at the top and
choose conditional formatting.

Then you can change the background color and font colour when the field is
greater than 5.

--
www.ae911truth.org

Thanks for your continued support. I think i'm nearly there but i don't know
how to write the conditional format. I assumed it would be;

Field Value is > Greater Then Or Equal To > 5

As in 5 days. I have entered test data and the field changes colour but
instead of a number just says #Name?

A really appreciate your help

This works:

add an extra read-only field and put in the control source:

=Date() - [Field]

where "field" is your date.

That will give you the difference in days.

Go to format -> Conditional formatting.

Then you change the formatting to highlight the field. As far as the whole
record is concerned I am not sure but it depends whether your form is
continuous or not.

--
www.ae911truth.org

Thanks. I'm getting an error message saying "The expression you entered
contains invalid syntax. You may have entered an operand without an operator"
It highlights "then" in between 5 and fieldname.forecolor = 000000

:


I can't see why not. I would have thought an "if" statement would work using
the difference between today and the record date something like (off the top
of my head):

if date() - [field] > 5 then fieldname.forecolor = 000000


--
www.ae911truth.org



:

Good Morning,

I have a side project (which is helping me learn for my massive main
project), which has time sensitive data stored on a table. Is it possible to
Highlight the record (I have already created a form for users to view the
data on a sub form), when a period of x amount of time has passed since the
record was added? Whether this be the text or cell highlighted i don't mind,
but it is only necessary to view in the subform.

Thanks in advance

Dave