Code Control Formats in which Event?

[MVP Wannabe]

I have a continuous form that I want to set field formatting on multiple
controls using VBA. I do not want to use the Conditional formatting.

Assuming I write my formatting code into a procedure, which event is the
appropriate place to invoke the code from?

Thanks

 

[ruralguy via AccessMonster.com]

Maybe this link will be useful:
http://accessdb.info/index.php?option=com_content&task=view&id=116&Itemid=40

 

[Marshall Barton]

I have a continuous form that I want to set field formatting on multiple
controls using VBA. I do not want to use the Conditional formatting.

Assuming I write my formatting code into a procedure, which event is the
appropriate place to invoke the code from?

You can not use code in an event procedure to set different
formats in different rows in a continuous or datasheet form.

There is a very messy workaround using multiple text boxes
on top of each other, but it rapidly goes out of control if
there are more than a few different formats.

Maybe I could make a more specific suggestion if you
explained what effect you are trying to achieve and why you
don't want to use Conditional Formatting.