|
|
VBA conditional formatting
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
|
|
0
|
|
|
|
Reply
|
 Utf
|
6/4/2010 9:36:31 AM |
|
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@discussions.microsoft.com> wrote in message
news:9BDFFD9C-52AB-41AB-B7BE-A54ABE016452@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?
|
|
|
0
|
|
|
|
Reply
|
Allen
|
6/4/2010 9:48:07 AM
|
|
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@discussions.microsoft.com> wrote in message
> news:9BDFFD9C-52AB-41AB-B7BE-A54ABE016452@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?
>
>
> .
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
6/4/2010 11:35:15 AM
|
|
|
2 Replies
865 Views
(page loaded in 0.048 seconds)
Similiar Articles: VBA conditional formatting - microsoft.public.accessHi there, I have read up about conditional formatting and understand the *concept* clearly (I think). However, is it possible to display conditio... Conditional Formatting -- Need VBA Code - microsoft.public.access ...Hi, Can someone help me out with some starting VBA code for conditional formatting? (I need more than the three conditions that the built-in f... Conditional Formatting: Change .BackColor on-the-fly? - microsoft ...Hi, Can someone help me out with some starting VBA code for conditional formatting? ... just need the text of a combo box on a continuous form to change color ... DLookup in Conditional Formatting? - microsoft.public.access.forms ...VBA conditional formatting - microsoft.public.access VBA conditional formatting - microsoft.public.access I ... Conditional Footer Code - microsoft.public.access ... Conditional Formatting Access 2007 - microsoft.public.access ...I am using conditional formatting for the backcolor on some controls in the detail section of the report. When I view the report in Print Preview, t... How to count cells that are highlighted by conditional formatting ...How do I return a count of how many cells in a range are highlighted (via conditional formatting) without using VBA in Excel 2007? ... Conditional formatting of detail section in an access form ...VBA conditional formatting - microsoft.public.access Conditional formatting of detail section in an access form ... VBA conditional formatting - microsoft.public.access ... how do I create "blink" conditional formatting ...how do I create "blink" conditional formatting? ... ... Hi You can't, you need VBA for that. See this link: http://www.cpearson.com/excel/BlinkingText.aspx HTH John ... Conditional Formatting - microsoft.public.access.formsHi, Can someone help me out with some starting VBA code for conditional formatting? (I need more than the three conditions that the built-in f... conditional formatting label?? - microsoft.public.access ...VBA conditional formatting - microsoft.public.access conditional formatting label?? - microsoft.public.access ... VBA Conditional Formatting of Charts by Value and Label ... Conditional Formatting: Get Around 3 Criteria Limit in Excel ...Conditional Formatting. How use VBA code to get around Excel's Conditional Formatting 3 criteria limit. The conditional formatting may be set incorrectly when you use VBA ...Discusses a workaround for a problem that occurs in Excel in which conditional formatting may be set incorrectly when you use a VBA macro. Excel Conditional format in VBA - MrExcel.com | Excel Resources ...Hi, I've set conditional formatting on a range. How do I find from a VBA module whether that condition was true or false for a given cell? Is conditional format ... Conditional formatting with VBA - Microsoft AnswersI'm using Excel 2010 and need a VBA macro that assigns conditional formatting to a group of cells using offset references to those cells. The following code clears ... Conditional Formatting: Adding Custom Conditional Formatting to ...In this section, you create the macro-enabled workbook containing the conditional formatting VBA code and the sample data. To do this, complete the following steps: 7/19/2012 3:56:16 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
72 followers. 