ColumnWidths

[Gordon Dale]

I am setting a query to return records othat match a name
from atable and using make-table to load the records into
a table named "NCR Result" using:

Private Sub SalesAddress_AfterUpdate()

DoCmd.OpenQuery "NCRSearch", , acReadOnly
DoCmd.OpenTable "NCR Result", , acReadOnly

End Sub

This works fine but the column widths are default sizes
and therefore hide half the info. I need to know how to
set the columnwidths when I display the form.

Regards



Gordon Dale

 

[Neil]

Gordon,

This is quite hard to do in MS Access (beleive it or not). I would recommend
going to Steven Lebens website
(http://www.lebans.com/listboxcolumnresize.htm) and downloading the
ListColumnResize class. This will automatically resize the columns for you.

HTH,

Neil.

 

[Stephen Lebans]

Neil I think you mean to point the OP to:
http://www.lebans.com/autocolumnwidth.htm

Further the OP must use a Form set to Datasheet view and not open the
tables directly in Table Datasheet view.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Neil]

Sorry, my fault

Yup, indeed, that is the one i was thinking of...

Neil.

 

[Guest]

Thanks guys

Am I suposed to use the autocolumny thing as a module
(install it in Access?) More use to Delphi coding than
VB!!

Regards

Gordon