question| Painting Rows

[mikichi]

hi,
i have a query that filter all that dates that biger from today:
">Date()"
on this query i build report.
i want that all the Date that start in the next week painting in Green.
how i can do that?


thank you,
miki

[JoeM]

First, in your query, build an expression to check to see if the date being returned is the next week number (when compared to the current date).
That expression will look something like:

WeekNumCheck: Format([DateField],"ww")=Format(Date(),"ww")+1

Now, you can use this field in Conditional Formatting on your report (Google "Access report conditional formatting if you do not know how to do this).
Basically, add your Date field and WeekNumCheck fields to your report (you can elect to make the WeekNumCheck field not visible, if you like).
Then, apply the Conditional Formatting to your Date field. You will want to use the "Expression is" option, and enter the following formula:

[WeekNumCheck]=True

and then choose your formatting colors.

[mikichi]

hi,
first sorry on the delay!!

its working good!
but i have a two problem now.
1.i want that Conditional Formatting paint all the record and not only the field.
2.when i start automatic design its canceld the Conditional Formatting.
tnak youuu!!!
miki

[JoeM]

but i have a two problem now.
1.i want that Conditional Formatting paint all the record and not only the field.
2.when i start automatic design its canceld the Conditional Formatting.

1. Apply the same conditional formatting to all the other fields in that record if you want them highlighted too.
2. Not sure what you mean by "automatic design".

[mikichi]

1. Apply the same conditional formatting to all the other fields in that record if you want them highlighted too.
2. Not sure what you mean by "automatic design".

1.but i cant :S every field can change only himself with conditional formatting no?
2.i mean to this :AutoFormats
http://office.microsoft.com/en-us/ac...004.aspx#BMbm1
thank you

[JoeM]

1.but i cant :S every field can change only himself with conditional formatting no?

Conditional Formatting can only change the field that the formula is being applied to, but the formula being used can look at the value of other fields! It is not relegated to only looking at its own value.

For example, if you have three fields named PatientName, Age, and VisitDate, and you wanted to highlight all three fields if your PatientName is "Bob", then you would just got to each field (one at a time, and set up the Conditional Formatting this way):
1. Choose the "Expression Is" option (instead of the "Field Value Is" option
2. Enter this expression: [PatientName]="Bob"
3. Choose your formatting option

I have never used the AutoFormats option before (not even sure if Access 2007 has it), but if you read through that article you posted, it looks like you would need to create your own AutoFormat (and not use one of the pre-built ones) if you wanted to incorporate conditional formatting.

[mikichi]

thank you very much!!!