Changing your column width in Datasheet view

When you change the width of a column in Design view, the new column width is seen only in Design view. If you want to change the column widths in the Datasheet view you can do so. Use the technique you learned to change the width of a column in Datasheet view, move the pointer to the right side of the column header and click and drag when you see the two-pointed arrow. The changes you make to the column width will stick that is, you will see the changed column width the next time you view the query datasheet.

Everyone who uses datasheets knows they are powerful, but very few people know all of the things you can do with them. One of the things that even the most diehard Visual Basic developer admits is that they wish that Visual Basic had a grid as powerful as the datasheet of Access . And with all of that power, there are still many things that no one knows how to do with them.
Datasheets are routinely dismissed by developers, who seem to favor continuous forms.
However, datasheets provide a simple yet powerful way to display data to your users. Datasheets also allow you to provide a user interface (UI) that your users can configure to meet their needs. Most developers feel that datasheets give too much control to their users.
However, by taking control of your datasheets, you can incorporate them into your applications. In this article, I will show some of the features of these powerful UI objects that most developers don't understand.