ACC: Incorrect PrtMip Example in Help

• Microsoft Access versions 7.0, 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you use the "PrtMip Property" example in Help, you may receive the following error message in Microsoft Access 7.0:

   The setting you entered isn't valid for this property

CAUSE

The Help example contains errors in the declarations of the two Type statements required for this procedure to work.

RESOLUTION

Use the following as the Type statements in the Declarations section of your module instead of what is in the Help example:

   Type str_PRTMIP
      RGB As String * 28
   End Type

   Type type_PRTMIP
      xLeftMargin As Long
      yTopMargin As Long
      xRightMargin As Long
      yBotMargin As Long
      fDataOnly As Long
      xWidth As Long
      yHeight As Long
      fDefaultSize As Long
      cxColumns As Long
      yColumnSpacing As Long
      xRowSpacing As Long
      rItemLayout As Long
      fFastPrint As Long
      fDatasheet As Long
   End Type

MORE INFORMATION

In Microsoft Access 7.0, the Help example declares a 56-character string in the Type str_PRTMIP statement. It is that statement which causes the error message. This documentation has been fixed in Microsoft Access 97.

The Help examples in both Microsoft Access 7.0 and 97 declare the elements in type_PRTMIP as Integer instead of Long. This does not cause an error message; however, the SetMarginsToDefault procedure in the Help example does not work unless you declare those elements as Long.

Steps to Reproduce Behavior