Autoresize column widths in Split Forms?

J

jonathanchye

Registered User.

Local time

Today, 08:00

Joined

Mar 8, 2011

Messages

448

• Mar 23, 2011

• #1

Hi,

I have a Split form with the datasheet displayed at the bottom. Is there anyway to force autoresize of column widths everytime form is loaded? Even if I resized once the widths automatically resets again afters...

Thank you.

 

boblarson

Smeghead

Local time

Today, 00:00

Joined

Jan 12, 2001

Messages

32,059

• Mar 23, 2011

• #2

I don't believe you can do that for a split form. If you want that functionality I believe you would need to create a subform and use it like the split form datasheet instead of a regulare split form.

 

J

jonathanchye

Registered User.

Local time

Today, 08:00

Joined

Mar 8, 2011

Messages

448

• Mar 23, 2011

• #3

well I have some subforms which displays as Datasheet but the columns don't autoresize either. Some of my end users would like Excel like view hence why I am looking for a presentable way of using datasheet view...

 

boblarson

Smeghead

Local time

Today, 00:00

Joined

Jan 12, 2001

Messages

32,059

• Mar 23, 2011

• #4

For that you would need to use a subform in datasheet view. You can then set things via code (see this article).

 

L

lution

Registered User.

Local time

Today, 02:00

Joined

Mar 21, 2007

Messages

114

• Feb 26, 2012

• #5

Set the tag to "?" for each of the controls you want to resize and then add the following:

Dim ctl as control

For Each ctl In Me.Controls
If ctl.Tag = "?" Then ctl.ColumnWidth = -2
Next

Click to expand...

Put this into the load event for the form and subform.

 

boblarson

Smeghead

Local time

Today, 00:00

Joined

Jan 12, 2001

Messages

32,059

• Feb 28, 2012

• #6

lution said:

Set the tag to "?" for each of the controls you want to resize and then add the following:




Put this into the load event for the form and subform.

Click to expand...

but doesn't work for the datasheet of a split form.

 

G

grahamvb

Registered User.

Local time

Today, 03:00

Joined

Aug 27, 2013

Messages

57

• Sep 27, 2013

• #7

I had the same problem. What worked for me (Access 2010 Split Form) was to resize all the columns (by dragging the right edge of the column header) the way I wanted, then right click any column header and select "Hide Column." Hide any column, click "Ok" then right click again on any column, choose "Unhide Column" and unhide the one you hid in the first place. Click "Ok" and presto the form opens with the resized column widths every time.

 

Last edited: Sep 27, 2013

J

jonathanchye

Registered User.

Local time

Today, 08:00

Joined

Mar 8, 2011

Messages

448

• Nov 27, 2013

• #8

grahamvb said:

I had the same problem. What worked for me (Access 2010 Split Form) was to resize all the columns (by dragging the right edge of the column header) the way I wanted, then right click any column header and select "Hide Column." Hide any column, click "Ok" then right click again on any column, choose "Unhide Column" and unhide the one you hid in the first place. Click "Ok" and presto the form opens with the resized column widths every time.

Click to expand...

Designing another database and ran into the same problem. I've tried your method but the changes will not last if I reboot PC or update client.

Same really as Columnwidth = -2 doesn't work on split forms I really don't want to create subform just to resize as I want to keep this as simple as possible.


The easiest way to auto resize seems to be 2 mouse clicks - click on top left to select all and double click on the right hand side of a column to autoresize. If it can be done manually I just don't understand why there's no method to do it programmatically!