Changing form ColumnWith

R

Roy Goldhammer

Hello there

I have form with subforms.

On the subforms there is only one field, and it is present as datasheet.

Is there a way to diterme the field columnWidth when it is on datasheet
mode?
 
B

Brendan Reynolds

Private Sub Form_Load()
'0=Design, 1=Form, 2=Datasheet
If Me.CurrentView = 2 Then
'1440 twips = 1 inch
Me.TestDate.ColumnWidth = 1440 * 2
End If
End Sub
 
Top