Globally Update the formatting of all forms

[Sandpiper]

Hi
I've been doing some work on an existing database which has included adding several new forms. As a result of this DB growing over several versions of access there are now all sorts of random formatting options on the forms.

Is there a way of updating all of the forms at the same size to a set font size, font style on the labels and text boxes and header background, detail background and footer background on the forms..etc.

I was about to start going through each form manually, but there are so many, I thought there must be a better way, but my vb isn't advanced enough to work it out.

Any help would be greatly appreciated.

Thanks very much

 

[Taruz]

Hi..

a part of your question about, there was a my file. i add..
colors you choose are applied to all forms..

 

[vbaInet]

To be honest we don't know what all your forms look like, their properties and their layouts we can't give you any code that would do a reasonable job.

Plus the fact that you're not an advanced user any code that is given to you may cause may harm than good.

 

[Sandpiper]

Thanks very much. The demo from Taruz is great.
I do know enough to be able to add to the code and update the text properties at the same time.
I'm OK with editing code, just not writing it from scratch
Thank you again for the responses.