Code Control Formats in which Event?

  • Thread starter Thread starter MVP Wannabe
  • Start date Start date
M

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
 
MVP said:
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?
Click to expand...


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.
 
Back
Top