Microsoft KB Archive/142931

= ACC95: "Not Enough Free Memory to Update Display" Error Message =

Article ID: 142931

Article Last Modified on 6/25/2002

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q142931



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you run Microsoft Access for Windows 95 version 7.0, you may receive the following error message:

Not enough free memory to update the display.

This error can occur at different times, for example:
 * When you open a database with a startup form (as specified in the Startup options on the Tools menu).
 * When you use a main form with a subform control that has its NavigationButtons property set to Yes.
 * When you change Windows system settings (such as fonts, printer drivers, colors, and so on) while a main form with a subform that contains navigation buttons is open.



RESOLUTION
The resolution is dependent on the action you were performing at the time you received the error message:

 If you receive the error message while opening a database with a startup form, you can use an AutoExec macro to open the form instead of the Startup options on the Tools menu. To do so, follow these steps:  On the Tools menu, click Startup. In the Startup box, under Display Form, select the (none) option. Click OK to close the Startup box. In the Database window, click the Macros tab, and then click New.  Create the following new macro: <pre class="fixed_text">         Macro Name    Action --         AutoExec      OpenForm

AutoExec Actions --         OpenForm Form Name: </li> Close and save the AutoExec macro.</li> Close and reopen your database. The AutoExec macro should open your startup form automatically when you open the database.</li></ol> </li> If you receive the error message while using a subform with the NavigationButtons property set to Yes, you can turn off the NavigationButtons property and add custom navigation buttons using the Command Button Wizard. If your subform is displayed in Datasheet view, you also need to change the DefaultView property to Continuous Forms. To do so, follow these steps: <ol> Open your main form in Design view and delete the subform control. Note that this deletes only the control, not the actual subform object which is listed under Forms in the Database window.</li> Switch to the Database window, click the Forms tab, and then click New.</li> In the New Form box, select the AutoForm: Tabular Wizard, select the table or query where the object's data comes from, and then click OK.</li>  View the new form in Design view, and then set the following form properties: <pre class="fixed_text">         DefaultView: Continuous Forms NavigationButtons: No                       </li>  Use the Command Button Wizard to add four new command buttons to the form footer section. In the Command Button Wizard, under Actions, select one of the following actions for each command button: <pre class="fixed_text">         Go to First Record Go to Last Record Go to Next Record Go to Previous Record </li> Close and save the new form as NewSubformTest.</li> Switch to your main form in Design view, and then drag the NewSubformTest form from the Database window to the main form and drop it in the former location of the original subform.</li> Customize the subform control as appropriate; for example, set the LinkChildFields and LinkMasterFields properties.</li> Save your main form and switch the form to Form view. The subform control should simulate a form Datasheet view.</li></ol> </li> If you receive the error message after you change Windows system settings while a mainform/subform that contains navigation buttons is open, you should quit Microsoft Access and restart the application. The best workaround for this situation is to quit Microsoft Access before you make any system changes.</li></ul>

<div class="status_section">

STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 7.0.

Keywords: kberrmsg kbbug kbfix kbenv KB142931

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.