Highlight fields

  • Thread starter Thread starter Ernst Guckel
  • Start date Start date
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.
 
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.
 
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...
 
Back
Top