I have a simple form with 4 fields in one row. The form is set to continuous forms so several records are visible at once. The fields are set so that when they "GotFocus" the back color changes from white to yellow...makes it easier to see what field you're in. The problem is that when you're in a field (Name), EVERY Name field changes color and I only want to change the field of the selected record.

Any ideas? Thanks!

if you are using A2k see:
http://www.access-programmers.co.uk/ubb/Forum4/HTML/001551.html http://www.access-programmers.co.uk/ubb/Forum4/HTML/002449.html

if A97 (it's complicated) but see:
http://www.access-programmers.co.uk/ubb/Forum4/HTML/003719.html

hth,
al

I have a simple form with 4 fields in one row. The form is set to continuous forms so several records are visible at once. The fields are set so that when they "GotFocus" the back color changes from white to yellow...makes it easier to see what field you're in. The problem is that when you're in a field (Name), EVERY Name field changes color and I only want to change the field of the selected record.

Any ideas? Thanks!

I know this is an old thread, but I thought I'd post a reply for anyone having the same problem:

You need to set the text box back style to transparent, then change the back color on gotfocus/lostfocus.