Bold Controls on form from values in Table

Hi Experts,
I have a question regarding the format of controls in a form. I have built a table that holds the source data for a form (the following is a small sample:

BusinessGroup RCode      ValueType      IMISmth       diffMth
A14116      TBA LIB      FUNDING      £15,374.36           £15,374.36
A14116      TBA AST      AVG BAL      -£5,264,000.00 -£10,527,574.53
A14116      IGNORE      COM INC      £0.00                -£2,873,212.21
A14116      Subtotal            -£5,225,248.45  -£17,991,551.32
A14118      TBA AST      AVG BAL      £101.91           -£173,511.67
A14118      IGNORE      COM INC      £0.00           -£12,225,066.23
A14118      TBA LIB      AVG BAL      £521,000.00           £521,000.00
A14118      IGNORE      COM INC      £0.00           -£12,225,066.23
A14118      TBA AST      AVG BAL      -£386.42           -£174,000.00
A14118      Subtotal            £520,715.49          -£24,276,644.13
A15014      294AST      AVG BAL      £0.00          -£6,267,651.00

Basically I am trying to format the form so that each row that contains "Subtotal" is bold (I need them to stand out from the other rows). I have tried doing this on the Load event of the form but can't get it to work.
Is it possible?
If so any ideas on the best way to achieve this?

Thanks

Martywal
Start Free Trial