Conditional Formating of a textbox

[Guest]

I know it can be done but cannot remember how. All I need is a way to change
the background colour of a text box or any input field so chow the user which
box they are on. I have managed to do this with got and lost focus but this
dont work with continuous forms as all the same field for all the records
change, I need on that is entered into the controls property, I will try and
get it by myself but any help would be much appreciated

 

[fredg]

I know it can be done but cannot remember how. All I need is a way to change
the background colour of a text box or any input field so chow the user which
box they are on. I have managed to do this with got and lost focus but this
dont work with continuous forms as all the same field for all the records
change, I need on that is entered into the controls property, I will try and
get it by myself but any help would be much appreciated

Access 2000 or newer?
Use the control's Conditional Formatting property.
Select the control.
Click on Format + Conditional Formatting
Set the Condition1 to Field Has Focus.
Set the color as required.
Save the change.

 

[Guest]

Thanks for your reply,
Dont know if I am crazy, but I have not seen a conditional formating option
on any of Access 2002's properties, can you please explain how you have it,
is it an addon or something.

Thanks

 

[Guest]

sorry just found it, thanks for the help

Access 2000 or newer?
Use the control's Conditional Formatting property.
Select the control.
Click on Format + Conditional Formatting
Set the Condition1 to Field Has Focus.
Set the color as required.
Save the change.