Setting column width

[Adam Molinaro]

I am using a macro to create a table, and am having trouble setting the
column width for some of my fields. For example, one of the columns is
populated with a timestamp (= Now), and when I view my table, I do NOT see
the full date without dragging the column heading with my mouse. I would try
to set this in the design view, however this table gets deleted then
recreated upon the macro-run. I looked into the ColumnWidth property, but
was having difficulty (perhaps simply syntax trouble, or perhaps this is just
for forms?).

Thoughts?

 

[Steve Schapel]

Adam,

As far as I know, you can't do this with a table. Normally, you should
never see the table, except for design and testing. Tables are for data
storage, not for data management, so the display functionality is
therefore limited. As you suggest, forms are for data
entry/edit/viewing, and this is where the "column" width becomes relevant.

 

[Adam Molinaro]

Thank you.

However, I am wondering how column widths in datasheets are defined? Where
are they defined? Isn't something in the code determining how narrow or wide
to make a particular column "look?"

 

[Adam Molinaro]

After thinking more about your reply, I simply created a quick form with a
datasheet view for my table. That solved my problem/query.

Thanks.

Adam.