Datasheet subform

[JeepsR4Mud]

Hello,

I have a subform which is a datasheet. Is there a way to set the column width? I've tried in the properties, and using the menu, etc.

My fields are case number, employee name, and a Yes/No column. Obviously, the employee name can expand or shrink the column, but I'd like to set the widths so the size fluxuation isn't distracting when going through the records.

It seems like a simple thing, but...

Thanks.

Gayle Ann

 

[keden]

I'm no pro but have you tried going into the table view and setting the widths there and saving the table design changes? I believe that the table field widths will stay when it is brought over to the sub.

 

[Pat Hartman]

You can change the column widths when the form is open in form view. When you have them adjusted, click save. Access will remember the setting the next time the form is opened.