Form got focus all fields (1 Viewer)

[Sticky99]

Could anybody tell me if it is possible to set gotfocus on form loading, what I am trying to achieve is to change colour of each field when selecting. I can do this on individual fields but would like to set this parameters for all field service on loading the form.

Thanks guys.

 

[Minty]

There are many methods of doing this, and they would all work after the form has loaded.
I would have a read here http://allenbrowne.com/highlight.html for a detailed example.

 

[Sticky99]

Thank you Minty, that is exactly what I’m looking for.

Much appreciated

 

[Minty]

You are welcome.

As a newcomer, you could do a lot worse than to carefully read all of Allen's pages and tips.

 

[Sticky99]

It’s now on my “to read” list. Again thanks.

 

[missinglinq]

I go to Allen's site anytime I run into a new problem, and have done so for years...it simply can't be beat...but this particular solution is really very simple:

In Form Design View:

• Hold down <Shift> and select each Control to be included
• Go to the Ribbon - Design Tab and click on Conditional Formatting
• Under Condition 1 select Field Has Focus from the dropdown box
• Select the formatting you desire using the BackColor (the paint bucket) and/or ForeColor icon(s)
• Click on OK

You're done. Takes less than a minute...regardless of the number of Controls...and requires no VBA code!

Linq ;0)>

 

[Sticky99]

I go to Allen's site anytime I run into a new problem, and have done so for years...it simply can't be beat...but this particular solution is really very simple:

In Form Design View:

• Hold down <Shift> and select each Control to be included
• Go to the Ribbon - Design Tab and click on Conditional Formatting
• Under Condition 1 select Field Has Focus from the dropdown box
• Select the formatting you desire using the BackColor (the paint bucket) and/or ForeColor icon(s)
• Click on OK

You're done. Takes less than a minute...regardless of the number of Controls...and requires no VBA code!

Linq ;0)>

Thanks missinglinq