Repost: Access Form Coding

[Daniel P]

I'm trying to attribute conditional formatting to a continuous user form. In a previous posting I was told:

"Take a look at Lebans.com for Steve Lebans stuff on conditional formatting -
he has example databases/code you can download - its very useful!!"

I've reviewed the sample database and it does demonstrate exactly what I want to do but I can't figure out how it works. There is no "On Load" event .... . I'm specifically interested in the "CusContinuous" form from the A2KConditionalFormattingVer27.mdb sample database. what code is controlling the colors for the form. What triggers it to work/load

Could someone explain it to me ......(Please!!!!)

Thank you,

Daniel

 

[Rob Oldfield]

Click on the background text box (txtBK) and go to Format, Conditional
Formatting.

I'm trying to attribute conditional formatting to a continuous user form.

In a previous posting I was told:

"Take a look at Lebans.com for Steve Lebans stuff on conditional formatting -
he has example databases/code you can download - its very useful!!"

I've reviewed the sample database and it does demonstrate exactly what I

want to do but I can't figure out how it works. There is no "On Load" event
..... . I'm specifically interested in the "CusContinuous" form from the
A2KConditionalFormattingVer27.mdb sample database. what code is controlling
the colors for the form. What triggers it to work/load?