Conditional Formatting

[Ajwebb]

Hi All,

Is it Possible to do Conditional Formatting on a Query.

Thanks

Ant

 

[jdegeorge]

Formatting of what? A form, report, and what on that form or report? Please be more descriptive, and possibly post any code you might already have tried.

Jim DeGeorge

 

[Ajwebb]

Formatting of a Report.

I have a report with Five Fields:-

StudentName, Scheme, TypeReview, PlannedDate, ActualDate

What i would like is if the Planned Date is Less than the Current Date, It to be made Red and Bold.

Thanks

Ant

 

[jdegeorge]

Student name? Are you a student doing homework?

Jim DeGeorge

 

[Ajwebb]

Hi Jim,

No i'm not a Student, However I work for a training organisation in Wales (UK). I'm designing a Database for my Company that will allow them to Track Learners whilst they are on training scheme with us.

Ant

 

[jdegeorge]

Ok. On the report's OnCurrent property, put this code:

If PlannedDate < Date Then
Me.PlannedDate.Font = 255
Endif

Hope this helps.

Jim DeGeorge

 

[Ajwebb]

Thanks Jim.

Ant

 

[jdegeorge]

Did it work?

Jim DeGeorge

 

[Ajwebb]

Hi Jim,

Couldn't find the OnCurrent of the Report, However found conditional formatting under the Format Tab.

However I have used something Similar now on my forms, so thanks again.

Do you know if it is possible to Conditional Format a Query?

Ant

 

[jdegeorge]

If you have the report open in DESIGN VIEW, the property list to the right should appear. Scroll down until you see ON CURRENT. Then, click on the ... to the right of that field.

Then, paste in the code I gave you above.

I don't know what you mean by conditions in a query. Please elaborate.

Jim DeGeorge