MS Access: Questions with editing columns

Asked By 10 points N/A Posted on -
qa-featured

Hi,

I was wondering if there is any way to wrap the text in the columns. Also, is there a way to adjust the column width automatically? I know how to do it manually, just wondering if it would adjust on its own.

Is there is anyone who can help me out?

Thanks!

SHARE
Best Answer by Ryan Baldwin
Best Answer
Best Answer
Answered By 0 points N/A #95393

MS Access: Questions with editing columns

qa-featured

Since you have the desire to alter the width of a section in a shape that is in datasheet view (which looks similar to the table), you are able to conform it mechanically by setting the .ColumnWidth to-2. The .ColumnWidth is ONLY ready in DataSheet view.

In shape, see the width of a segment if situated with the .Width property. To get the information to wrap, you are able to make the column, while in datasheet view, taller.

The process could need to be finished manually. Doing the height cannot be done with the program code. Therefore, following these instructions would be best.

Answered By 0 points N/A #95395

MS Access: Questions with editing columns

qa-featured

Follow these procedures:

  • Private sub worsheet_change(ByVal target As Range)
  • With me .cells
  • .Rows.Autofit
  • .Columns.Autofit
  • End with
  • End sub

Thanks!

Login/Register to Answer

Related Questions