Mess with MS Access reports
Informatics, Uncategorized | (0)
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:
Declare Function SetWindowLong Lib "user32" _
Alias "SetWindowLongA" (ByVal hwnd As Long, ByVal _
nIndex As Long, ByVal dwNewLong As Long) As Long
Declare Function GetWindowLong Lib "user32" _
Alias "GetWindowLongA" ...