Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2010
Access 2010
Access 2010 Developer Reference
Access Object Model Reference
Form Object
Properties
Form.ActiveControl Property (Access)
Form.AfterDelConfirm Property (Access)
Form.AfterFinalRender Property (Access)
Form.AfterInsert Property (Access)
Form.AfterLayout Property (Access)
Form.AfterRender Property (Access)
Form.AfterUpdate Property (Access)
Form.AllowAdditions Property (Access)
Form.AllowDatasheetView Property (Access)
Form.AllowDeletions Property (Access)
Form.AllowEdits Property (Access)
Form.AllowFilters Property (Access)
Form.AllowFormView Property (Access)
Form.AllowLayoutView Property (Access)
Form.AllowPivotChartView Property (Access)
Form.AllowPivotTableView Property (Access)
Form.Application Property (Access)
Form.AutoCenter Property (Access)
Form.AutoResize Property (Access)
Form.BeforeDelConfirm Property (Access)
Form.BeforeInsert Property (Access)
Form.BeforeQuery Property (Access)
Form.BeforeRender Property (Access)
Form.BeforeScreenTip Property (Access)
Form.BeforeUpdate Property (Access)
Form.Bookmark Property (Access)
Form.BorderStyle Property (Access)
Form.Caption Property (Access)
Form.ChartSpace Property (Access)
Form.CloseButton Property (Access)
Form.CommandBeforeExecute Property (Access)
Form.CommandChecked Property (Access)
Form.CommandEnabled Property (Access)
Form.CommandExecute Property (Access)
Form.ControlBox Property (Access)
Form.Controls Property (Access)
Form.Count Property (Access)
Form.CurrentRecord Property (Access)
Form.CurrentSectionLeft Property (Access)
Form.CurrentSectionTop Property (Access)
Form.CurrentView Property (Access)
Form.Cycle Property (Access)
Form.DataChange Property (Access)
Form.DataEntry Property (Access)
Form.DataSetChange Property (Access)
Form.DatasheetAlternateBackColor Property (Access)
Form.DatasheetBackColor Property (Access)
Form.DatasheetBorderLineStyle Property (Access)
Form.DatasheetCellsEffect Property (Access)
Form.DatasheetColumnHeaderUnderlineStyle Property (Access)
Form.DatasheetFontHeight Property (Access)
Form.DatasheetFontItalic Property (Access)
Form.DatasheetFontName Property (Access)
Form.DatasheetFontUnderline Property (Access)
Form.DatasheetFontWeight Property (Access)
Form.DatasheetForeColor Property (Access)
Form.DatasheetGridlinesBehavior Property (Access)
Form.DatasheetGridlinesColor Property (Access)
Form.DefaultControl Property (Access)
Form.DefaultView Property (Access)
Form.Dirty Property (Access)
Form.DisplayOnSharePointSite Property (Access)
Form.DividingLines Property (Access)
Form.FastLaserPrinting Property (Access)
Form.FetchDefaults Property (Access)
Form.Filter Property (Access)
Form.FilterOn Property (Access)
Form.FilterOnLoad Property (Access)
Form.FitToScreen Property (Access)
Form.Form Property (Access)
Form.FrozenColumns Property (Access)
Form.GridX Property (Access)
Form.GridY Property (Access)
Form.HasModule Property (Access)
Form.HelpContextId Property (Access)
Form.HelpFile Property (Access)
Form.HorizontalDatasheetGridlineStyle Property (Access)
Form.Hwnd Property (Access)
Form.InputParameters Property (Access)
Form.InsideHeight Property (Access)
Form.InsideWidth Property (Access)
Form.KeyPreview Property (Access)
Form.LayoutForPrint Property (Access)
Form.MaxRecButton Property (Access)
Form.MaxRecords Property (Access)
Form.MenuBar Property (Access)
Form.MinMaxButtons Property (Access)
Form.Modal Property (Access)
Form.Module Property (Access)
Form.MouseWheel Property (Access)
Form.Moveable Property (Access)
Form.Name Property (Access)
Form.NavigationButtons Property (Access)
Form.NavigationCaption Property (Access)
Form.NewRecord Property (Access)
Form.OnActivate Property (Access)
Form.OnApplyFilter Property (Access)
Form.OnClick Property (Access)
Form.OnClose Property (Access)
Form.OnConnect Property (Access)
Form.OnCurrent Property (Access)
Form.OnDblClick Property (Access)
Form.OnDeactivate Property (Access)
Form.OnDelete Property (Access)
Form.OnDirty Property (Access)
Form.OnDisconnect Property (Access)
Form.OnError Property (Access)
Form.OnFilter Property (Access)
Form.OnGotFocus Property (Access)
Form.OnInsert Property (Access)
Form.OnKeyDown Property (Access)
Form.OnKeyPress Property (Access)
Form.OnKeyUp Property (Access)
Form.OnLoad Property (Access)
Form.OnLostFocus Property (Access)
Form.OnMouseDown Property (Access)
Form.OnMouseMove Property (Access)
Form.OnMouseUp Property (Access)
Form.OnOpen Property (Access)
Form.OnResize Property (Access)
Form.OnTimer Property (Access)
Form.OnUndo Property (Access)
Form.OnUnload Property (Access)
Form.OpenArgs Property (Access)
Form.OrderBy Property (Access)
Form.OrderByOn Property (Access)
Form.OrderByOnLoad Property (Access)
Form.Orientation Property (Access)
Form.Page Property (Access)
Form.Pages Property (Access)
Form.Painting Property (Access)
Form.PaintPalette Property (Access)
Form.PaletteSource Property (Access)
Form.Parent Property (Access)
Form.Picture Property (Access)
Form.PictureAlignment Property (Access)
Form.PictureData Property (Access)
Form.PicturePalette Property (Access)
Form.PictureSizeMode Property (Access)
Form.PictureTiling Property (Access)
Form.PictureType Property (Access)
Form.PivotTable Property (Access)
Form.PivotTableChange Property (Access)
Form.PopUp Property (Access)
Form.Printer Property (Access)
Form.Properties Property (Access)
Form.PrtDevMode Property (Access)
Form.PrtDevNames Property (Access)
Form.PrtMip Property (Access)
Form.Query Property (Access)
Form.RecordLocks Property (Access)
Form.RecordSelectors Property (Access)
Form.Recordset Property (Access)
Form.RecordsetClone Property (Access)
Form.RecordSource Property (Access)
Form.RecordSourceQualifier Property (Access)
Form.ResyncCommand Property (Access)
Form.RibbonName Property (Access)
Form.RowHeight Property (Access)
Form.ScrollBars Property (Access)
Form.Section Property (Access)
Form.SelectionChange Property (Access)
Form.SelHeight Property (Access)
Form.SelLeft Property (Access)
Form.SelTop Property (Access)
Form.SelWidth Property (Access)
Form.ServerFilter Property (Access)
Form.ServerFilterByForm Property (Access)
Form.ShortcutMenu Property (Access)
Form.ShortcutMenuBar Property (Access)
Form.SplitFormDatasheet Property (Access)
Form.SplitFormOrientation Property (Access)
Form.SplitFormPrinting Property (Access)
Form.SplitFormSize Property (Access)
Form.SplitFormSplitterBar Property (Access)
Form.SplitFormSplitterBarSave Property (Access)
Form.SubdatasheetExpanded Property (Access)
Form.SubdatasheetHeight Property (Access)
Form.Tag Property (Access)
Form.TimerInterval Property (Access)
Form.Toolbar Property (Access)
Form.UniqueTable Property (Access)
Form.UseDefaultPrinter Property (Access)
Form.VerticalDatasheetGridlineStyle Property (Access)
Form.ViewChange Property (Access)
Form.ViewsAllowed Property (Access)
Form.Visible Property (Access)
Form.Width Property (Access)
Form.WindowHeight Property (Access)
Form.WindowLeft Property (Access)
Form.WindowTop Property (Access)
Form.WindowWidth Property (Access)
Expand Minimize
This topic has not yet been rated - Rate this topic

Form.MaxRecords Property (Access)

Office 2010

Specifies the maximum number of records by a query or view. Read/write Long.

expression .MaxRecords

expression A variable that represents a Form object.

When you set this property in Visual Basic you use the ADO MaxRecords property.

Records are returned in the order specified by the query's ORDER BY clause.

You can use the MaxRecords property in situations where limited system resources might prohibit a large number of returned records.

To return the MaxRecords property for a form, you can use the following:

VBA
Copy 
Dim l As Longl = Forms(formname).MaxRecords

To set the MaxRecords property, you can use the following:

VBA
Copy 
Forms(formname).MaxRecords = numrecords
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.