HOW TO FORMAT conditioning, My Version 97?

O

ooxx

Hello Fp;

After trying to make conditional formating many times, I found out that
I need your much advices. In my version is 97 , so Can this one make a one
conditional formating ? I need not to update to a newer one. hu hu.

Thanks,
 
A

Allen Browne

Conditional formatting is not possible in Access 97 or earlier.

The one thing you can do is change the Format of a Number type field: one
value/color for negative, one for positive, and one for zero. In this way,
you can create a flag that changes contents and color, depending on the data
in another field.

Example, assuming you want to show marker beside the records where
InvoiceDate is more than 60 days ago:

Control Source: =(Date() - [InvoiceDate] > 60)
Format: [Blue]\A;[Red]\Z
 
O

ooxx

Thanks,

Can the Background color be made as well ?
It's almost !

Thanks ,

Allen Browne said:
Conditional formatting is not possible in Access 97 or earlier.

The one thing you can do is change the Format of a Number type field: one
value/color for negative, one for positive, and one for zero. In this way,
you can create a flag that changes contents and color, depending on the data
in another field.

Example, assuming you want to show marker beside the records where
InvoiceDate is more than 60 days ago:

Control Source: =(Date() - [InvoiceDate] > 60)
Format: [Blue]\A;[Red]\Z

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

ooxx said:
After trying to make conditional formating many times, I found out
that
I need your much advices. In my version is 97 , so Can this one make a
one
conditional formating ? I need not to update to a newer one. hu hu.

Thanks
 
A

Allen Browne

I don't think it can change the background colour as well.
Certainly works to flag the rows visually though.

BTW, I assume we are talking continuous forms here?
In Form view, you can use the Current event of the form to set the BackColor
property of your controls.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

ooxx said:
Thanks,

Can the Background color be made as well ?
It's almost !

Thanks ,

Allen Browne said:
Conditional formatting is not possible in Access 97 or earlier.

The one thing you can do is change the Format of a Number type field: one
value/color for negative, one for positive, and one for zero. In this
way,
you can create a flag that changes contents and color, depending on the
data
in another field.

Example, assuming you want to show marker beside the records where
InvoiceDate is more than 60 days ago:

Control Source: =(Date() - [InvoiceDate] > 60)
Format: [Blue]\A;[Red]\Z

ooxx said:
After trying to make conditional formating many times, I found out
that
I need your much advices. In my version is 97 , so Can this one make a
one
conditional formating ? I need not to update to a newer one. hu hu.

Thanks
 
Top