Change the color of detail section

[DubboPete]

Hi all

I'd like to keep the color of the detail section to
"-2147483633" (grey) until a field is updated in the header section,
throwing the focus in the Form Open action to the particular header
section's field. After update of this field, the detail section color
should change to "65535" (yellow)

I think this is possible - I just don't know how to identify the
detail section in code...

thanks in anticipation

DubboPete

 

[Jeanette Cunningham]

DubboPete,
you can use Me.Section(0) for the detail section.
For example
Me.Section(0).Backcolor = 65535


Jeanette Cunningham -- Melbourne Victoria Australia

 

[DubboPete]

DubboPete,
you can use Me.Section(0) for the detail section.
For example
Me.Section(0).Backcolor = 65535

Jeanette Cunningham -- Melbourne Victoria Australia










- Show quoted text -

Thanks Jeanette!

never thought of Section(0) before, but I guess it can apply to other
things and instances too, which I might try before harrassing the
group!

guess you know where I live too then? haha

DubboPete
Dubbo, New South Wales, Australia

 

[Jeanette Cunningham]

Hi Pete from Dubbo,
you can also get help from vba help like this:
in the immediate window type the word section and while the cursor is still
in it, hit the F1 key.

If you want to get help when in the code editor, you need to make sure the
word you want help on is a separate word which has a space either side of
it, not some other control name or a dot right next to it (usually).


Jeanette Cunningham -- Melbourne Victoria Australia

DubboPete,
you can use Me.Section(0) for the detail section.
For example
Me.Section(0).Backcolor = 65535

Jeanette Cunningham -- Melbourne Victoria Australia










- Show quoted text -

Thanks Jeanette!

never thought of Section(0) before, but I guess it can apply to other
things and instances too, which I might try before harrassing the
group!

guess you know where I live too then? haha

DubboPete
Dubbo, New South Wales, Australia