Command button on a datasheet?

Topic

New Reply

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

Reply | Quote

Replies

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”

Reply | Quote

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

Reply | Quote