Modify a spreadsheet control so it looks like a text box control
By hiding the control'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 control look like the text box controls on the page.
- Open the data access page in Design view.
- Activate the spreadsheet control, and then display the Spreadsheet Property Toolbox.
- Click the Show/Hide bar, then hide the toolbar, gridlines, title bar, column headers, and row headers by clicking their respective buttons so they aren't pressed in.
- Click the Advanced bar, and then do the following:
- Set AutoFit spreadsheet to True.
- Set Viewable range to the cell or cells you want to display. For example, to display the value in cell A1, set the Viewable range to A1.
- Select the cells whose borders you want to change.
- In the Spreadsheet Property Toolbox, if the Format section is not expanded, click the Format bar.
- In the Cell format group, click the Borders button.
- Do one of the following:
- To specify a border color, click the Border Color button, and then select the same border color as the other controls you're trying to match on the data access page.
- To specify border width, click a size in the list.
- In the border diagram, click a border line to turn the border on or off. Click an intersection point to turn on or off all borders connected to that intersection.
- If necessary, move the control to its final location on the data access page.
Notes
- If you're changing the settings for borders that were specified previously, in the border diagram you need to click the existing border line to turn it off, and then click the same border line again to turn it back on with the new border color and width settings you specified.
- When you view the data access page in Page view or Internet Explorer, you won't see the new border when the control has the focus. Move focus away from the spreadsheet to see the effect.