sizing

[slimjen]

all, using access 2010. I have a form with a number of fields. One of those fields is a 2 digit state abbr. I set each field a different size according to the data it's holding. All the fields appear to be 1in wide. No matter what I do; the size will not appear as I set it. I don't know what's wrong. I have it set to datasheet view because its a 1:many subform. help

[ItsMe]

Design changes made while in Design View do not always translate to Datasheet View. Try opening your form in DS view, click and hold the field name and drag the width of the column to the desired size, like you would in Excel. Now save your form, being careful not to save something like a filter property to your form.

[slimjen]

Thanks for responding. I'll try this.

[Missinglinq]

Or, you could use code like this:

Private Sub Form_Load()
  Me.Field1Name.ColumnWidth = -2
  Me.Field2Name.ColumnWidth = -2
End Sub

This causes Controls in Datasheet View Forms to automatically size to fit the widest data in the given column. Just replace Field1Name and Field2Name with your actual names.

Linq ;0)>

[ItsMe]

Huh, I did not know that. I think I am going to use that in the project I am working on now.

[Missinglinq]

Just one point I thought of, when looking at this again! If it's in the Form_Load event, it sizes the column to the widest data existing when the Form loads! If you put it in the Form_Current event, however, it will resize the columns when the Form loads and when you move off of a New Record, if necessary!

Linq ;0)>

[ItsMe]

Hmm. In DS view I don't think the current event fires unless you change focus from one row to another.

[Missinglinq]

Hmm. In DS view I don't think the current event fires unless you change focus from one row to another.

Well, yeah! Moving from 'one row to another' is actually moving from one record to another...which is when Form_Current fires in any view! So if you enter a value for a Field that is longer than any previously entered value, for that Field, when you move to another Record the column will resize to accommodate it; you don't have to wait until you re-open the form for this to happen.

Linq ;0)>