How to change field format

[lflopes]

Hello. I'm triyng to change every field format in a Form each time I jump from one field to another. I want it to get grey and bold when it got the focus

I managed it with a GetFocus and Lost Focus for each field but whena form has a lot of fields it gets "a lot" of programing.

Is there a way of doing it another way, for instance On current

Thanks

 

[pbaldy]

Have you looked at Conditional Formatting, presuming you have A2k or later?

 

[Pat Hartman]

Look into creating a class module. This is what they are supposed to be used for. I'm sorry but I don't have any examples to share.

 

[ChrisO]

If you already have it for a small number of controls then could you post that code?

 

[gemma-the-husky]

I've seen examples of this, but it all has to be done with anonter/onexit or gotfocus/lostfocus event, as you say, and its clearly a pain to set up in the first place, especially if you have lots of forms.

I save and recover my forms positions and sizes in the onload and on close events and thats bad enough, but thats only 1 per form.

 

[lflopes]

Have you looked at Conditional Formatting, presuming you have A2k or later?

Conditional formating is the best.

No swet from now on..

Thanks