VBA conditional formatting
in [General]
|
From: PsyberFox on 4 Jun 2010 05:36 Hi there, I have read up about conditional formatting and understand the *concept* clearly (I think). However, is it possible to display conditional formatting of a subform in datasheet view on a form? If so, can someone please help me with the VBA coding of this, as I need to have more than 3 (or 4 if default is used) colours? Thank you! W -- The Psyber Fox http://www.psyberconsulting.co.za
From: Allen Browne on 4 Jun 2010 05:48 If you use VBA code to set the properties of the controls (ForColor etc), it will affect all rows of the datasheet, so no: that's not possible. You can use that approach in a report: that's probably your only option if you need more than 3 formats. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "PsyberFox" <PsyberFox(a)discussions.microsoft.com> wrote in message news:9BDFFD9C-52AB-41AB-B7BE-A54ABE016452(a)microsoft.com... > Hi there, > > I have read up about conditional formatting and understand the *concept* > clearly (I think). However, is it possible to display conditional > formatting > of a subform in datasheet view on a form? If so, can someone please help > me > with the VBA coding of this, as I need to have more than 3 (or 4 if > default > is used) colours?
From: PsyberFox on 4 Jun 2010 07:35 Thank you for the info... -- The Psyber Fox http://www.psyberconsulting.co.za "Allen Browne" wrote: > If you use VBA code to set the properties of the controls (ForColor etc), it > will affect all rows of the datasheet, so no: that's not possible. > > You can use that approach in a report: that's probably your only option if > you need more than 3 formats. > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia > Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org. > > > "PsyberFox" <PsyberFox(a)discussions.microsoft.com> wrote in message > news:9BDFFD9C-52AB-41AB-B7BE-A54ABE016452(a)microsoft.com... > > Hi there, > > > > I have read up about conditional formatting and understand the *concept* > > clearly (I think). However, is it possible to display conditional > > formatting > > of a subform in datasheet view on a form? If so, can someone please help > > me > > with the VBA coding of this, as I need to have more than 3 (or 4 if > > default > > is used) colours? > > > . >
|
Pages: 1 Prev: Access2007 Combo Box Next: Unable to read message content |