<div>
Or how about this? 
 
Private Sub ResizeCommentsSubForm() 
&nbsp; &nbsp; Forms![frmEntriesForm]![frmCommentsSUB]![TimeStamp].ColumnWidth = -1 
&nbsp; &nbsp; Forms![frmEntriesForm]![frmCommentsSUB]![CommentType].ColumnWidth = -1 
&nbsp; &nbsp; Forms![frmEntriesForm]![frmCommentsSUB]![Comment].ColumnWidth = 4000 &nbsp; 'twips 
End Sub 
 
(I found my old code for handling this)
</div>

Or how about this?

Private Sub ResizeCommentsSubForm()
    Forms![frmEntriesForm]![frmCommentsSUB]![TimeStamp].ColumnWidth = -1
    Forms![frmEntriesForm]![frmCommentsSUB]![CommentType].ColumnWidth = -1
    Forms![frmEntriesForm]![frmCommentsSUB]![Comment].ColumnWidth = 4000   'twips
End Sub

(I found my old code for handling this)

<div>
<div class="content wysiwyg-content">
I need a way to programmatically adjust the size of the columns in a subform so the scrollbar goes away. 
 
Something akin to double-clicking the column seperators to force them to the size of the header. 
 
Here is a picture depicting what I want to accomplish: 
 
<a href="http://www.robotzgame.com/junk/subform_resize.gif" rel="ugc">http://www.robotzgame.com/junk/subform_resize.gif</a> 
 
Thanks, 
 
Tom
</div>
</div>

I need a way to programmatically adjust the size of the columns in a subform so the scrollbar goes away.

Something akin to double-clicking the column seperators to force them to the size of the header.

Here is a picture depicting what I want to accomplish:

http://www.robotzgame.com/junk/subform_resize.gif

Thanks,

Tom

Programmatically resize subform datagrid display

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.