Can I put textbox/button on a datasheet form?

User avatar
Peter Kinross
5StarLounger
Posts: 962
Joined: 09 Feb 2010, 00:33
Location: Patterson Lakes, Victoria, Australia

Can I put textbox/button on a datasheet form?

Post by Peter Kinross »

I am pretty sure I know the answer to this one.
Can I put button on a datasheet form, or make a textbox look like a bit like a button? I have a textbox with the text 'Click to requery'. This works well and shows up with every record in datasheet view. I have been trying to get it to look like a button.
Avagr8day, regards, Peter

User avatar
HansV
Administrator
Posts: 78383
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Can I put textbox/button on a datasheet form?

Post by HansV »

On a datasheet view form, command buttons will only be visible in the form header or form footer section, not in the detail section.

You can't really make a text box in the detail section look like a button - it is just a cell in the grid. The only thing you can do with it is conditional formatting - you could make the text bold and the background color stand out, for example.
Best wishes,
Hans

User avatar
Peter Kinross
5StarLounger
Posts: 962
Joined: 09 Feb 2010, 00:33
Location: Patterson Lakes, Victoria, Australia

Re: Can I put textbox/button on a datasheet form?

Post by Peter Kinross »

That sure does make it stand out from the data. Not like a button, but better than before.
Thanks Hans
Avagr8day, regards, Peter