fixed column/cell height in datasheet view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Controlling Columns in Datasheet View 7
Best Fit Column Width for Datasheets 0
Be able to Center the texct in datasheet View 1
Datasheets 7
Fixed widths in datasheet columns 4
datasheet view 2007 without saving column layout changes 2
arrow selector in datasheet view? 2
Freeze columns 1

Back
Top