Setting column width

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

Guest

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?
 
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.
 
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?"
 
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.
 
Back
Top