What is the simplest method to add a delete button at the end of each record in a datasheet view?
What is the simplest method to add a delete button at the end of each record in a datasheet view?
Can't. But can make a textbox act like a button. Textbox has a Click event.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Yes that is a smart idea, I created a textbox with text "X", but unfortunately I am unable to apply any formatting to it.
I made it bold with font red, but when showing as datasheet all the formatting is gone.
Any idea?
Probably best can do is set DisplayAsHyperlink property to Always.
Alternative is to use ContinuousView and arrange controls to look like datasheet.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you, that is a nice solution.
I also tried another thing, I applied conditional formatting on the new textbox, it now looks different from other text boxes.
I just have one more question, since now i have a delete button for each record, is there a way to hide the record selector from the datasheet?
You mean the boxes on left side of window? No, not in Datasheet view.
Clever application of Conditional Formatting.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.