Color in date field

[sysop470]

Hi..

I have a field date and i need that on particular dates for example on the 01/01/2011,05/01/2011 etc etc the back color will become red for example. The date is already entered in the database.

thanks for you help.

 

[missinglinq]

Is this form in Single, Continuous or Datasheet View?

This kind of formatting can be done in code in the Form_Current event or using Conditional Formatting for a Single View Form.

For Continuous or Datasheet View Forms it has to be done in Conditional Formatting.

How you do this, using either method, and the associated limits, with either method, depends on what exactly the etc etc is that you mention!

How many of these dates are there?

Linq ;0)>

 

[sysop470]

Is this form in Single, Continuous or Datasheet View?

This kind of formatting can be done in code in the Form_Current event or using Conditional Formatting for a Single View Form.

For Continuous or Datasheet View Forms it has to be done in Conditional Formatting.

How you do this, using either method, and the associated limits, with either method, depends on what exactly the etc etc is that you mention!

How many of these dates are there?

Linq ;0)>

Thanks for your help..
It is a continuous form. There are approx. around 50 dates.

 

[missinglinq]

As I said, for a Continuous Form you're going to have to use Conditional Formatting, and with 50 possible dates that could very well be problematic! Is there any rhyme or reason to these dates, i.e. is there any expression that can be used to identify them, or do they reside in a separate table, or exactly where do they come from?

A more detailed view of your scenario might help us help you with this.

Linq ;0)>

 

[sysop470]

As I said, for a Continuous Form you're going to have to use Conditional Formatting, and with 50 possible dates that could very well be problematic! Is there any rhyme or reason to these dates, i.e. is there any expression that can be used to identify them, or do they reside in a separate table, or exactly where do they come from?

A more detailed view of your scenario might help us help you with this.

Linq ;0)>

Thanks for your help. The user enters the date and also i have 3 tick boxes.
Tick boxes are VL,SL,PH. those that tick box is in VL field, then the back color of the date should be RED otherwise remains BLACK.

Hope that this helps you

 

[missinglinq]

Then it doesn't matter how many dates you're talking about and we're getting close, now!

Question now is, are these three check boxes independent of each other or are they part of an Option Group, wher only one of the three can be ticked?

Linq ;0)>

 

[sysop470]

Then it doesn't matter how many dates you're talking about and we're getting close, now!

Question now is, are these three check boxes independent of each other or are they part of an Option Group, wher only one of the three can be ticked?

Linq ;0)>

Thanks again.. Only one can be ticked...