 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / May 2008Change the color of detail section
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 DubboPete, you can use Me.Section(0) for the detail section. For example Me.Section(0).Backcolor = 65535 Jeanette Cunningham -- Melbourne Victoria Australia > Hi all > [quoted text clipped - 10 lines] > > DubboPete On May 13, 10:21 pm, "Jeanette Cunningham" <n...@discussions.microsoft.com> wrote: > DubboPete, > you can use Me.Section(0) for the detail section. [quoted text clipped - 19 lines] > > - 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 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 On May 13, 10:21 pm, "Jeanette Cunningham" <n...@discussions.microsoft.com> wrote: > DubboPete, > you can use Me.Section(0) for the detail section. [quoted text clipped - 23 lines] > > - 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.