Show All

Make a spreadsheet look like a text box

By hiding the component's spreadsheet features, adjusting the color of cell borders to match other controls on the data access page, and sizing the control to a cell or range of cells, you can make the spreadsheet look like the text box controls on the page.

1. Open the data access page in Design view.
2. Activate the spreadsheet.
3. Right-click the control, and then click Commands and Options.
4. On the Sheet tab, clear the following check boxes: Row headers, Column headers, and Gridlines.
5. On the Workbook tab, clear the following check boxes: Horizontal scrollbar, Vertical scrollbar, Sheet selector, and Toolbar.
6. On the Advanced tab, clear the AutoFit Spreadsheet check box.
7. Resize the control by dragging the selection handles.
8. On the Sheet tab, set Viewable range to the cells you want to display. For example, to display the value in cell A1, set the Viewable range to A1.
9. Select the cells whose borders you want to change.
10. On the Format tab, in the Cell format group, set the border options to match the other controls on the data access page.