fixed column/cell height in datasheet view

P

Patrick Stubbin

I ahve seen, and use, a fixed columnwidth module for datasheets


does anyone know how to fix the cell height in datasheet view (ie freeze it)
so u cannot adjust it ' on the fly'

pat
 
B

Brendan Reynolds

Private Sub Form_Open(Cancel As Integer)
Me.TimerInterval = 250 'quarter of a second
End Sub

Private Sub Form_Timer()
Me.RowHeight = -1 'default height for current font
End Sub

The user will be able to click and drag to re-size the row, but it will
immediately snap back.
 
P

Patrick Stubbin

thanku

pat


Brendan Reynolds said:
Private Sub Form_Open(Cancel As Integer)
Me.TimerInterval = 250 'quarter of a second
End Sub

Private Sub Form_Timer()
Me.RowHeight = -1 'default height for current font
End Sub

The user will be able to click and drag to re-size the row, but it will
immediately snap back.
Click to expand...
 
Top