Format datasheets
Saturday, May 17th, 2008 |In Access the appearance of standard data sheets is white and gray lines, but you do not like the normal aspect, we can change the look as follows:
- After opening the data sheet you want to change go to the Format menu and choose Data Sheets.
- You will see the table formatting datasheets. In the first option have the effect of the cells, which may be flat, raised and sunken. The last two options only allow us to obtain an aspect of high or low relief and we can not choose anything else, the option plan that is able to choose more effects.
- The second option is Gridlines which allows us to choose whether you want the vertical or horizontal lines active or not.
- Background Color: as the name suggests is to choose the color of the cells just choose one from the list.
- Color of grid lines: the same function as in the preceding paragraph but for the grid lines.
- Border styles and line: change the appearance of gridlines, underline the column header and the border style of the data sheet. In the left list choose the line you want to change and list on the right line style.
- Direction: here we can change how the fields are presented in terms of order, we have the normal direction is from left to right or we can choose from right to left which will change the order of the fields and pull the right part Data Sheet. What we can see in figure 2. Note: this change can only be done on tables and not on data sheets on the forms.
Picture1:
Picture 2:
