A Datasheet Conundrum

[Paul H]

Hello folks,

I've been playing with datasheets for weeks now. It seems like I've learned a lot, but I've been having problems setting column widths in certain cases.

There are three fields that vary widely in widths and I've found I can use the On Current event to resize them on the run. I have two forms. On one it works like magic. On the second one I am stumped. I've been using the .columnwidth = -2 very successfully, but on Form 2 it ignores whatever value I put in.

Here is an example I used to test the code.

 
 
' Me.ID_1.ColumnWidth = 4000
' MsgBox "Column width is " & Me.ID_1.ColumnWidth

The message I get back is

Column width is 1860

This gives me the same result.

 
 
' Me.ID_1.ColumnWidth = -2
' MsgBox "Column width is " & Me.ID_1.ColumnWidth

I'm stumped. Any ideas?

[Paul H]

Here's another clue. I dragged the column wider in Form View, saved it and it retained the width I set. It still doesn't respond to code.