If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional formatting of detail section in an access form
I'm stuck in the following problem:
- Access 2003 - Form in datasheet view (tabular form) - Want to format (change the background color of) details section based on a value of a text box contained in it using VBA - Can't find where to put a statement like: Me.Section(acDetail).Backcolor = vbWhite so that the background would be colored correspondingly. The coloration appears only when the condition is met on the first record (row) shown and it spreads over all records (rows) I want to have the right color in those rows only where the condition is met. TIA for help |
#2
|
|||
|
|||
Conditional formatting of detail section in an access form
On Thu, 21 Jan 2010 13:05:19 +0100, PBradac
wrote: Check out "Conditional Formatting" in the Help file. -Tom. Microsoft Access MVP I'm stuck in the following problem: - Access 2003 - Form in datasheet view (tabular form) - Want to format (change the background color of) details section based on a value of a text box contained in it using VBA - Can't find where to put a statement like: Me.Section(acDetail).Backcolor = vbWhite so that the background would be colored correspondingly. The coloration appears only when the condition is met on the first record (row) shown and it spreads over all records (rows) I want to have the right color in those rows only where the condition is met. TIA for help |
#3
|
|||
|
|||
Conditional formatting of detail section in an access form
Hello Tom and thanks for your answer.
I've tried Help before but I couldn't find the answer. In Help it's all about changing the formatting properties *of the control based on its value*. What I want is to change a formatting property of the whole details section where the control is (based on the control's value of course). E.g. if a text box shows a negative value I want the whole detail section to show in red not just the text in the textbox. It's simple to change the color of the details section in VBA, but where do I have to put Me.Section(acDetail).Backcolor = vbRed so that it will be "executed" for the row where the textbox with negative value is situated. Primoz On Thu, 21 Jan 2010 06:39:29 -0700, Tom van Stiphout wrote: On Thu, 21 Jan 2010 13:05:19 +0100, PBradac wrote: Check out "Conditional Formatting" in the Help file. -Tom. Microsoft Access MVP I'm stuck in the following problem: - Access 2003 - Form in datasheet view (tabular form) - Want to format (change the background color of) details section based on a value of a text box contained in it using VBA - Can't find where to put a statement like: Me.Section(acDetail).Backcolor = vbWhite so that the background would be colored correspondingly. The coloration appears only when the condition is met on the first record (row) shown and it spreads over all records (rows) I want to have the right color in those rows only where the condition is met. TIA for help --- news://freenews.netfront.net/ - complaints: --- |
#4
|
|||
|
|||
Conditional formatting of detail section in an access form
On Thu, 21 Jan 2010 15:11:15 +0100, PBradac
wrote: I see the dilemma now. You can set conditional formatting to controls, not to the Details section itself. Perhaps that suffices though. -Tom. Microsoft Access MVP Hello Tom and thanks for your answer. I've tried Help before but I couldn't find the answer. In Help it's all about changing the formatting properties *of the control based on its value*. What I want is to change a formatting property of the whole details section where the control is (based on the control's value of course). E.g. if a text box shows a negative value I want the whole detail section to show in red not just the text in the textbox. It's simple to change the color of the details section in VBA, but where do I have to put Me.Section(acDetail).Backcolor = vbRed so that it will be "executed" for the row where the textbox with negative value is situated. Primoz On Thu, 21 Jan 2010 06:39:29 -0700, Tom van Stiphout wrote: On Thu, 21 Jan 2010 13:05:19 +0100, PBradac wrote: Check out "Conditional Formatting" in the Help file. -Tom. Microsoft Access MVP I'm stuck in the following problem: - Access 2003 - Form in datasheet view (tabular form) - Want to format (change the background color of) details section based on a value of a text box contained in it using VBA - Can't find where to put a statement like: Me.Section(acDetail).Backcolor = vbWhite so that the background would be colored correspondingly. The coloration appears only when the condition is met on the first record (row) shown and it spreads over all records (rows) I want to have the right color in those rows only where the condition is met. TIA for help --- news://freenews.netfront.net/ - complaints: --- |
#5
|
|||
|
|||
Conditional formatting of detail section in an access form
Tom,
not very happy :-(, but thanks anyway :-). I was wondering if moving the focus through the records (and by it through rows in datasheet) could somehow help. I'll give it a try. Regards, Primoz On Thu, 21 Jan 2010 07:20:35 -0700, Tom van Stiphout wrote: On Thu, 21 Jan 2010 15:11:15 +0100, PBradac wrote: I see the dilemma now. You can set conditional formatting to controls, not to the Details section itself. Perhaps that suffices though. -Tom. Microsoft Access MVP Hello Tom and thanks for your answer. I've tried Help before but I couldn't find the answer. In Help it's all about changing the formatting properties *of the control based on its value*. What I want is to change a formatting property of the whole details section where the control is (based on the control's value of course). E.g. if a text box shows a negative value I want the whole detail section to show in red not just the text in the textbox. It's simple to change the color of the details section in VBA, but where do I have to put Me.Section(acDetail).Backcolor = vbRed so that it will be "executed" for the row where the textbox with negative value is situated. Primoz On Thu, 21 Jan 2010 06:39:29 -0700, Tom van Stiphout wrote: On Thu, 21 Jan 2010 13:05:19 +0100, PBradac wrote: Check out "Conditional Formatting" in the Help file. -Tom. Microsoft Access MVP I'm stuck in the following problem: - Access 2003 - Form in datasheet view (tabular form) - Want to format (change the background color of) details section based on a value of a text box contained in it using VBA - Can't find where to put a statement like: Me.Section(acDetail).Backcolor = vbWhite so that the background would be colored correspondingly. The coloration appears only when the condition is met on the first record (row) shown and it spreads over all records (rows) I want to have the right color in those rows only where the condition is met. TIA for help --- news://freenews.netfront.net/ - complaints: --- --- news://freenews.netfront.net/ - complaints: --- |
Thread Tools | |
Display Modes | |
|
|