Can VBA change color of text on sub data sheet?

[PL01]

Can VBA code change the color of specific text on a sub data sheet that displays in a form? Something like conditional formatting can, but using VBA code.

 

[PWise]

form!subformcontrolname!form!controlname!ForeColor=

 

[MajP]

Maybe. Depends on exactly what you mean. If it is a continuous form then vba will change the color of every row. If you mean specific text within other text strings this can be done using rich text tags, but the coding is a little difficult to do this.

 

[PL01]

Not familiar with rich text tags...is this available with Access2003? Anyway, Access can't find the subform error message for Forms![tablet subform].[Price].ForeColor = 255 where [tablet subform] is the name of the subform. Thanks

 

[PWise]

Forms![tablet subform].[Form].[Price].ForeColor = 255

 

[MajP]

Rich Text is only available in 2007 or later. PWise's solution will change the color of every row if it is a continuous Subdatasheet. That may or may not be what you are looking for. Again, what do you mean by specific text: specific row, specific text within a string, specific control in single form view, other?

 

[PL01]

specific row would do it...just some of the records showing in the sub data sheet...similar with conditional formatting

 

[MajP]

As stated, if it is a continuous view vba will change the color of every row; you have to use conditional formatting to change colors of specific row.