Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Newtown, Pennsylvania, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Command button on a datasheet?

    I have form with a subform. The subform is presented as a datasheet, and one of the fields is set up so that if it is double-clicked it pops up another form with a lot more information on it. One of my users has asked if it would be possible to have a command box (with text saying 'click here') associated with each record on the subform. The double-click has the functionality I want, but as often the case, users want more!

    I tried setting up a command box, but it gets converted to a toggle control, with no text. Is there anyway I can work around this request - other than putting large text on the form telling the user to double click on the first field?

    Thanks,

    kiwi44

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Command button on a datasheet?

    What you can do, (and I do this a lot) is create a command "button", size it to cover whatever area you like in your datasheet view,use format to bring it to front, make it transparent and set the ControlTip Text for the button to whatever you like "click here for full information"

  3. #3
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Newtown, Pennsylvania, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Command button on a datasheet?

    Thanks, Brian - for some reason, on my database that didn't seem to work on first attempt. I need to go back and try it again ...

    Kiwi44

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •