Is FormHeader Active ?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • prakashwadhwani@gmail.com

    Is FormHeader Active ?

    I have a continuous form. When the user presses the Down-Arrow, I'd
    like to know if the active control was in the FormHeader, FormBody or
    FormFooter section.

    Is there any way to trap this ?

    Best Rgds,
    Prakash
  • Allen Browne

    #2
    Re: Is FormHeader Active ?

    Test the Section property of the control, e.g.:

    If Me.ActiveContro l.Section = acDetail Then

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    <prakashwadhwan i@gmail.comwrot e in message
    news:8e5e373d-5f2c-427c-a529-6172dcb7b95a@i2 9g2000prf.googl egroups.com...
    >I have a continuous form. When the user presses the Down-Arrow, I'd
    like to know if the active control was in the FormHeader, FormBody or
    FormFooter section.
    >
    Is there any way to trap this ?
    >
    Best Rgds,
    Prakash

    Comment

    • prakashwadhwani@gmail.com

      #3
      Re: Is FormHeader Active ?

      On Mar 5, 6:55 pm, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
      Test the Section property of the control, e.g.:
      >
      If Me.ActiveContro l.Section = acDetail Then
      >
      --
      Allen Browne - Microsoft MVP. Perth, Western Australia
      Tips for Access users -http://allenbrowne.com/tips.html
      Reply to group, rather than allenbrowne at mvps dot org.
      >
      <prakashwadhw.. .@gmail.comwrot e in message
      >
      news:8e5e373d-5f2c-427c-a529-6172dcb7b95a@i2 9g2000prf.googl egroups.com...
      >
      I have a continuous form. When the user presses the Down-Arrow, I'd
      like to know if the active control was in the FormHeader, FormBody or
      FormFooter section.
      >
      Is there any way to trap this ?
      >
      Best Rgds,
      Prakash

      Muchos Gracias Allen !! Worked like a charm.
      I came very close to it (while going through the Access Help) ...
      apparently not close enough though. :-)

      Thx again,
      Best Rgds,
      Prakash.

      Comment

      • prakashwadhwani@gmail.com

        #4
        Re: Is FormHeader Active ?

        On Mar 5, 6:55 pm, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
        Test the Section property of the control, e.g.:
        >
        If Me.ActiveContro l.Section = acDetail Then
        >
        --
        Allen Browne - Microsoft MVP. Perth, Western Australia
        Tips for Access users -http://allenbrowne.com/tips.html
        Reply to group, rather than allenbrowne at mvps dot org.
        >
        <prakashwadhw.. .@gmail.comwrot e in message
        >
        news:8e5e373d-5f2c-427c-a529-6172dcb7b95a@i2 9g2000prf.googl egroups.com...
        >
        I have a continuous form. When the user presses the Down-Arrow, I'd
        like to know if the active control was in the FormHeader, FormBody or
        FormFooter section.
        >
        Is there any way to trap this ?
        >
        Best Rgds,
        Prakash

        Muchos Gracias Allen !! Worked like a charm.
        I came very close to it (while going through the Access Help) ...
        apparently not close enough though. :-)

        Thx again,
        Best Rgds,
        Prakash.

        Comment

        Working...