Add or remove scroll bars

ShowAdd or remove scroll bars for a form or for a text box on a form

By default, a form has vertical and horizontal scroll bars that appear only when necessary. Also, by default, when you create a text box based on a Memo (Memo data type: In a Microsoft Access database, this is a field data type. Memo fields can contain up to 65,535 characters.) field in a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.), or when you create a text box based on a text (text data type: In an Access project, a variable-length data type that can hold a maximum of 2^31 - 1 (2,147,483,647) characters; default length is 16.) or ntext (ntext data type: In an Access project, a variable-length data type that can hold a maximum of 2^30 - 1 (1,073,741,823) characters. Columns with the ntext data type store a 16-byte pointer in the data row, and the data is stored separately.) column in an Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.), Access adds a vertical scroll bar to the text box. Otherwise, a scroll bar doesn't appear in a text box unless you change the value of the ScrollBars property. Follow this procedure only if you want to change the default behavior.

  1. Open the form in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
  2. Do one of the following:
  3. Click the Format tab, and in the ScrollBars property box, do one of the following:
    • To specify that a scroll bar for a text box never appears, click None.
    • To specify that a scroll bar for a form never appears, click Neither.
    • To specify that a vertical scroll bar for a text box always appears, click Vertical.
    • To specify that a vertical scroll bar for a form appears when necessary, click Vertical Only.
    • To specify that a horizontal scroll bar for a form appears when necessary, click Horizontal Only.
    • To specify that both vertical and horizontal scroll bars appear when necessary, click Both.

ShowAdd or remove scroll bars for a text box on a data access page

By default, scroll bars for a text box based on a Memo field appear only when necessary; if the text box is based on a field whose data type isn't Memo, the scroll bars do not appear at all. Follow this procedure only if you want to change the default behavior.

  1. Open the data access page in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
  2. Click the text box, and then click Properties Button image on the toolbar.
  3. Click the Format tab, and do one of the following:
    • To specify that scroll bars never appear in the text box, set the Overflow, OverflowX, and OverflowY properties to Hidden.
    • To specify that scroll bars appear in the text box only when necessary, set the Overflow, OverflowX, and OverflowY properties to Auto.
    • To add a vertical scroll bar to a text box, set the OverflowX property to Hidden and the OverflowY property to Scroll.
    • To add a horizontal scroll bar to a text box, set the OverflowX property to Scroll and the OverflowY property to Hidden.
 
 
Applies to:
Access 2003