Add button and set that's visibility using vba

[ali_sh]

Hello
I added a button to report for each record.


I need a vba code to change visibility of the button according to number in a field of table in each row.
Can you help me write this code?
Thanks in advance

[June7]

Button will only be interactive when report is in ReportView, not PrintPreview. Code setting visibility property of a control has to be in Format event and Format event executes only for PrintPreview (or direct to printer). Therefore, can't do what you want with button. Can make a textbox look sort of like a button or a hyperlink and use Conditional Formatting to enable/disable.

Forms are intended to be interactive and reports for display.

[GinaWhipp]

Hmm, if this is on a continuous Form then you can't do it that way. Technically there is only one button and it is either visible or not visible. Perhaps something like this will give you the desired result...
https://regina-whipp.com/blog/?p=1227