yronium
Level: Moderator
Registered: 14-04-2002
Posts: 907
|
Re: change the width of column in access table
Hello. It doesn't make much sense.
You are speaking about a column width, as a field has no width. In fact, a field is only a data container and its properties don't include any graphical information.
Column width is determined by the interface you are using for viewing data: you can view data by MSAccess' Table window, or maybe by an Access form, or a VB form, or a web page, or a text file, or a message box, or even a slider control, or else. According with the viewing method, you could use a control or another to show fields values, with columns or not, so you could have the need to resize a grid column, or a textbox, or a textboxes array, or a messagebox, or a web page html table, etc.
Nothing of the above can be specified via ADOX or another data provider, and VB or VBA instructions depend on the control you use.
Finally, if you are looking for a way to automatically resize a column in MSAccess Table View window, it's only possible via normal Access' interface tools, Format menu or right click column's header, and they can not be driven by any external instruction (and it is the correct behaviour of every compiled application, like MSAccess). Even VBA code is working only within Access' forms, in Forms viewing mode.
Hope it helps
____________________________
Real Programmer can count up to 1024 on his fingers
|
