Highlight fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ernst Guckel - 29 Mar 2008 16:23 GMT

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.

Reply to this Message

fredg - 29 Mar 2008 16:37 GMT

> Hello,
>
[quoted text clipped - 3 lines]
>
> Ernst.

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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Ernst Guckel - 29 Mar 2008 17:35 GMT

Thanks.

Ernst.

> > Hello,
> >
[quoted text clipped - 16 lines]
>
> Do the same for any other control wanted.

Reply to this Message