Subform with Datasheet View Problem

[NoSmoke]

Hello all (haven't been here for a while).

I have recently added a subform to a form and wish to display the subform in Datasheet view. Whilst I can get the proper data and headings to display, I cannot figure out how to get the column widths to persist. I can adjust the column widths while in (main) form view right on the subfirm columns themselves but after I save and reload the main & subform form, the widths revert to some sort of default value. I have also tried adjusting the columns in the subform's associated data table itself as well as adjusting the text box widths when the subform is displayed in Form view but it does not affect the column widths when the subform displays Datasheet view.

What is more annoying is that I have another subform in which I was able to make the Datasheet view column widths persist but I don't seem to be able to properly recall how I did it.

Any help here would be much appreciated... TIA

 

[spikepl]

After adjusting the widths, right-click on one of the column headers, select Unhide , and then click Close.

 

[NoSmoke]

After adjusting the widths, right-click on one of the column headers, select Unhide , and then click Close.

OK, tried Unhide & Close but no cigar. Then tried Freeze Fields and it worked.

Thanks for pointing me in the right direction!

But one other question if I could - is there any way of persisting the monitor view when switching back and forth between Form View and Design View? All that scrolling down is wearing out my mouse.