Auto resize field

[musclecarlover07]

This is a bit of an odd request. I would liek for my first and last name fields width to match the length of the name. So if the last name is Smith then the field width will resize itself to fit perfect fit the name. THen if I have a last name of Connor then it will grow to fit it perfect. I dont need this but it will be nice so everything looks a bit nicer an cleaner.
i thought the following would have worked:

Me.Lastname.width = Len(Me.Lastname]

 

[Pat Hartman]

Are you talking about a form or a report? In either case, you won't be able to do it without putting the form/report into design view and resizing the control. This won't work if you distribute an .mde/.accde or run the application with the Access Runtime engine. Best option - for a form - leave it alone since the form is probably used for data entry and so each record will have different size fields. For a report - concatenate the FirstName and LastName fields into the full name and bind the report to that field.

Select ... FirstName & " " & LastName As FullName, ...
From ...;