Conditional Formating of a textbox

M

mikejs2000

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
 
F

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
Click to expand...

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.
 
M

mikejs2000

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
 
M

mikejs2000

sorry just found it, thanks for the help

fredg said:
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.
Click to expand...
 
Top