How to Alternate Row Colors in Microsoft Access

Save

Microsoft Access provides small businesses with a database solution to store records, such as customer information, orders and product descriptions. When you print out reports in Microsoft Access, the grids are set up with a white background by default. Setting up alternate row colors make the Access reports easier to read for your users. The alternative colors are set up in the Properties window for your row grid.

  • Click the Windows "Start" button and select "All Programs." Click "Microsoft Office," then click "Microsoft Access" to open the database software.

  • Press "Ctrl" and "O" after the Access software loads. Double-click your Access file to open it. Double-click the report form to display it in your workspace.

  • Right-click the grid where you display your Access records. Select "Properties" to open the window where you set up row colors.

  • Click the Back Color text box. A button appears. Click it to open a color selector tool. Click the color you want to use as the first color.

  • Click the Alternate Back Color text box. Click the button that appears on the right to open the color selector. Click the color you want to use as the alternate background color. Click "Close" to close the Properties window.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!