Hi All,

I am using access 2003. I have a subform which displays 3 fields derived from a query filtered via a combo box. The whole thing works well except that One of the fields is a memo field that can have quite long descriptions. My problem is that whilst I can arrange the field widths manually on the subform, this formatting is not saved and I can find no subform property that allows me to set the field widths in the subform. Can anyone tell me whether it is possible to do this with code and if so give me a line or two of code to demonstrate how it is done,

many thanks :)

HowardB

You can change the field width using VBA. The property you are looking for is Width.

However, I suspect something else is going on. You should be able to save the field width when you set it manually.

Do you have the form's "Allow Design Changes" property set to "All Views" or "Design View Only"?

If you are allowing design changes only in design view, then when you manually set the width of the field, changes won't be saved.

Try working with the subform directly (don't use the main form). In design view make sure that the you allow changes in all views. Show data in form. Adjust the width of your field, save changes and close the form. Then open the main form and see if the width isn't as wide as you previously made it.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

And if the width is still not big enough, remember that people can zoom in on any field in any form by using Shift+F2. Just put a label on your form somewhere reminding people of that.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division