Problem changing a BackColour of a textBox in my report!
Hi guys,
I have a slight problem formatting one of the text boxes in my report. I want the colour of the text box (BackColor) to turn grey when the value of another field (Tag_Tgt_Diff) is > 0. However when doing the code the BackColour property for the text boxes in the report is not available! so I am not able to change the colour of text box using this method.
I have read some comments about conditional formatting but as I am a beginner in Access (I am using Access 97) I am not sure how to do this. I have attached an example database with this thread to show you what I am trying to do. in the code for "subrpt1" i have used an IF statement and set the text box colour to grey, this actually does execute with no errors but it wont make the changes on the report!
Can you please tell me how I can sort this out!? Thank you for putting your time into this.
Maisam
Hi guys,
I have a slight problem formatting one of the text boxes in my report. I want the colour of the text box (BackColor) to turn grey when the value of another field (Tag_Tgt_Diff) is > 0. However when doing the code the BackColour property for the text boxes in the report is not available! so I am not able to change the colour of text box using this method.
I have read some comments about conditional formatting but as I am a beginner in Access (I am using Access 97) I am not sure how to do this. I have attached an example database with this thread to show you what I am trying to do. in the code for "subrpt1" i have used an IF statement and set the text box colour to grey, this actually does execute with no errors but it wont make the changes on the report!
Can you please tell me how I can sort this out!? Thank you for putting your time into this.
Maisam
Last edited:
