Highlighting active control in a form

[WJReid]

Hi All,

Can anyone tell me how to highlight the active control on a form, either the backcolour or the border colour, as you tab through the form?

Thanks for any help in advance

Regards,

Bill

 

[NateO]

On 2002-11-22 01:23, WJReid wrote:
Hi Nate,

My computer must also be crazy!!!

Your code worked perfectly on the example you sent. On my computer, it still didn't work for the first 4, worked for the next 4, then stopped working.

I think I'll have to start from scratch with the form and use your code to see if it makes any difference.

Thanks once again Nate.

Regards,

Bill

Wait, so it worked perfectly and then didn't work?? I'm definately going in for an evaluation after this thread.

I started this in xl 2000 then tested it in '97.

I have no clue as to what the damage is or how to control it at this point.

Post yer code Willy!

 

[technix]

On 2002-11-22 14:04, NateO wrote:

Well I wasnt Crazy until I attempted to do this on my crazy computer. Everything Appears to be correct not sure

Derrick

Hey Dude, I opened your .frm file, I didn't even see an enter or exit event. Which is a problem.

Now I'm going crazy.

Please post the problematic code to this thread so the board can evaluate both our sanity levels.

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-11-22 14:06

_I must have sent you the form after I deleted it all as I Was getting to frustrated, I Guess I Will Just give up as I cannot get it to work, if by chance you do get it to work in that .frm I sent you please explain how Thanks anyway

Derrick
________________
This message was edited by technix on 2002-11-22 22:34

 

[NateO]

_I must have sent you the form after I deleted it all as I Was getting to frustrated, I Guess I Will Just give up as I cannot get it to work, if by chance you do get it to work in that .frm I sent you please explain how Thanks anyway

Derrick

Howdy Derrick, send me the file tomorrow (not tonight). But send the entire workbook. Trim the send version down as much as possible, e.g., form & form code. From there I'm sure we can iron this out.