Highlight fields

E

Ernst Guckel

Hello,

I'm not sure if we can do this but I have an Employee info form that has
required fields on it. I want to highlight ALL the required fields and once
data is entered to return them back to normal. Any ideas??

Ernst.
 
F

fredg

Hello,

I'm not sure if we can do this but I have an Employee info form that has
required fields on it. I want to highlight ALL the required fields and once
data is entered to return them back to normal. Any ideas??

Ernst.
Click to expand...

You can use the Control's Conditional Formatting for this.
Select the control you wish to do this in.
Click on Format + Conditional Formatting
For Condition1 select
Expression Is
write
[FieldName] Is Null
in the next box.
Select the back color
Click OK.

Do the same for any other control wanted.
 
E

Ernst Guckel

Thanks.

Ernst.

fredg said:
Hello,

I'm not sure if we can do this but I have an Employee info form that has
required fields on it. I want to highlight ALL the required fields and once
data is entered to return them back to normal. Any ideas??

Ernst.
Click to expand...

You can use the Control's Conditional Formatting for this.
Select the control you wish to do this in.
Click on Format + Conditional Formatting
For Condition1 select
Expression Is
write
[FieldName] Is Null
in the next box.
Select the back color
Click OK.

Do the same for any other control wanted.
Click to expand...
 
Top