Can you use a cmd button to change the backcolor of a textgbox? 1

[testkitt2]

Hello to all
I have a DB that I, and 2 other people use at the job. I'm trying to setup a command button with VB code that upon clicking that cmd button it will change the backcolor of that textbox to whatever I set the color too. The thing is I need the command button to be able to change the backcolor of just about any of one or more textboxes currently on the form. but only one at a time. The way it should work is this...If you need to change the color of a textbox just click into the textbox to set the focus then click the command button.
The reason I need this.....
The changing of the color will be used as a highlighter so that if another user seas a color on a record he or she knows that the information in that textbox may change or may need to be changed. I can't use conditonal formatting cause I dont know what will be typed into some of the textboxes.
Any help is appreciated.
Thanks
JZ

Testkitt2

 

[Eupher]

Well done as usual, AceMan. No, I haven't tried my method with a continuous or datasheet forms. As you suggest, I'm fairly certain it would not work. Is the OnCurrent event invoked with continuous forms?

Ken S.

 

[TheAceMan1]

[blue] Is the OnCurrent event invoked with continuous forms?[/blue]

In any form view . . . [blue]Absolutely![/blue]

. . . and what happended to [blue]testkitt2 ?[/blue]

See Ya! . . . . . .