MS Access: Questions with editing columns

Asked By ronaltfeder 10 points N/A Posted on - 07/29/2011

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!

• Status: Open
• Question Views: 984
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Ryan Baldwin

Go To Solution

Best Answer

Best Answer

Answered By Ryan Baldwin 0 points N/A #95393

MS Access: Questions with editing columns

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.

About Ryan Baldwin

Questions
1

Answers
4

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 07/29/2011
• Question Category: MS Access

Answered By jewel uddin 0 points N/A #95395

MS Access: Questions with editing columns

Follow these procedures:

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

Thanks!

About jewel uddin

Questions
0

Answers
31

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 07/30/2011
• Question Category: MS Access