Conditional Formatting on a Subform

[Guest]

Hi all,

I'm using Access 2000 SP3 and I've successfully been able to conditionally
format a field on a continuous form. It works fine until I add it as a
subform to my main form. All of the data displays, but not with the
conditional formatting. The main form is a single form (versus continuous or
datasheet). Any ideas why?

I've Googled newsgroups and searched this newsgroup but I haven't found any
problems reported with this.

Thanks you,
Jeff

 

[Guest]

Jeff,

As long as you are using a field value from your subform or an expression
which refers only to constants or another field on your subform, the
conditional formatting should work. If your expression refers to a control
on your main form, you will need to use the Parent property to refer to it.
For example, to refer to a control named "CustomerID" on the main form, the
syntax is:

Parent.Form![CustomerID]

Hope that helps.
Sprinks

 

[Guest]

Thank you very much for your reply.

Yes, I was referring to a field value within the subform and as I said it
works fine if I open the subform by itself. The conditional formatting goes
away after I add the subform to my Parent form. I just tried starting from
scratch in a new database with just two tables and minimal info and I get the
same result. I thought I could attach the new database to this reply but it
doesn't look like that will work

Any other suggestions?

Jeff
(e-mail address removed)
(without the no and spam)

Jeff,

As long as you are using a field value from your subform or an expression
which refers only to constants or another field on your subform, the
conditional formatting should work. If your expression refers to a control
on your main form, you will need to use the Parent property to refer to it.
For example, to refer to a control named "CustomerID" on the main form, the
syntax is:

Parent.Form![CustomerID]

Hope that helps.
Sprinks

Hi all,

I'm using Access 2000 SP3 and I've successfully been able to conditionally
format a field on a continuous form. It works fine until I add it as a
subform to my main form. All of the data displays, but not with the
conditional formatting. The main form is a single form (versus continuous or
datasheet). Any ideas why?

I've Googled newsgroups and searched this newsgroup but I haven't found any
problems reported with this.

Thanks you,
Jeff