Mess with MS Access reports

When designing a MS Access form you can easily disable the minimize and maximize buttons by selecting the appropriate option in the form’ properties window. Such an option doesn’t exist for Access reports. However you can still mess with these report’ features by making use of VBA and the Win32 API.

To disable the minimize and or maximize buttons of a report window, place the following code in a VBA code module:

Then write the following code for the report’ OnOpen event:

Simply comment out one of the lines to disable only the minimize or maximize button.