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.
Can I put textbox/button on a datasheet form?
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Can I put textbox/button on a datasheet form?
Avagr8day, regards, Peter
-
- 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?
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.
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
Hans
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Can I put textbox/button on a datasheet form?
That sure does make it stand out from the data. Not like a button, but better than before.
Thanks Hans
Thanks Hans
Avagr8day, regards, Peter