asked on

Field width in datasheet view not cooperating

I have a form which when opened in single form view is fine. But I also want to open this form in datasheet view via a command button on the main menu and set one of the fields to be a set length which is wider than the user sees it in form view.

How can this be done?

--Steve

Jeffrey Coachman

If you open the form in Datasheet view, then resize the columns to the size you want, ...they should remain that way when you close and reopen the form...

JeffCoachman

SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Gustav Brock

Set the property ColumnWidth of the column to the desired width.

/gustav

SteveL13

ASKER

I have tried adjusting the column width when the form opens in datasheet view but it won't remember it the next time I open it. Here is the code for the onclick event of the command button:

DoCmd.OpenForm "frmTourGuides", acFormDS, , , acFormEdit, acWindowNormal

Remember, I have a form which when opened in single form view is fine. But I also want to open this form in datasheet view via a command button on the main menu and set one of the fields to be a set length which is wider than the user sees it in form view.