By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Conditional formatting in a continuous form

P: 50
Hi guys,

I want my 'Hours' record within my continuous form to be red background if the 'Category' section for that entry is set to 'Absent'. I am using this form as a subform within a main form.

I have tried when expression is...

[Forms]![FrmHoursSubform]![Category]="Holiday"

and...

[Forms]![FrmHoursRpt].[FrmHoursSubform]![Category]="Holiday"

...ANY IDEAS WHERE IM GOING WRONG (probably something simple!)
May 15 '08 #1
Share this Question
Share on Google+
3 Replies


puppydogbuddy
Expert 100+
P: 1,923
Hi guys,

I want my 'Hours' record within my continuous form to be red background if the 'Category' section for that entry is set to 'Absent'. I am using this form as a subform within a main form.

I have tried when expression is...

[Forms]![FrmHoursSubform]![Category]="Holiday"

and...

[Forms]![FrmHoursRpt].[FrmHoursSubform]![Category]="Holiday"

...ANY IDEAS WHERE IM GOING WRONG (probably something simple!)
If [FrmHoursRpt] is your main form and [FrmHoursSubform] is your subform control, then reference syntax should be:


[Forms]![FrmHoursRpt]![FrmHoursSubform].Form![Category]="Holiday"
May 15 '08 #2

P: 50
I have tried the conditional formatting;

expression is...

[Forms]![FrmHoursRpt]![FrmHoursSubform].Form![Category]="Holiday"

but it doesn't work...

i have also tried applying conditional formatting 'on current' of form using the expression above and it does not work either, any ideas???
May 16 '08 #3

P: 50
Sorted, after all this time I just had to put expression is...

[Category] = "Holiday"!
May 16 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.