Multiline field?

[amberlynn]

Is it possible to set a field on a form (in datasheet view) to be multiline, to prevent the text from being cut off?


Thanks,
Amber

 

[dhookom]

I thought word wrap was the default behaviour in datasheet view. What isn't happening that you think should be? Have you set the height of the row? This won't happen automatically.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[amberlynn]

The form is actually a subform. When I look at it in design view, it looks like it is in form view, but when I change from design view to form view, the subform swtiches to datasheet view.
I have one text box that contains a lengthy description, and it cuts off where the text exceeds one line.
The height property is set by default, I can change it, but it has no effect when in datasheet view.

 

[dhookom]

You must manually adjust the height of your datasheet rows. This will affect all rows in the datasheet (they are not independent).

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[amberlynn]

So the user must manually drag the height of the line to fit all the text?
I can't have it automatically adjust to fit the longest text for the current record?

 

[dhookom]

I am not aware of any code that would automatically adjust the height of the rows in datasheet view.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[missinglinq]

With the exception of the number and names of the controls that you've placed on a form, Access basically ignores anything else you've done in Design View when you present a form in Datasheet View! You can stack textboxes one on top of the other, make the background color red, make one textbox invisible, and when it appears in Datasheet View they all appear, including the "invisible" one, side by side rather than stacked. The whole idea, really, is for the form to emulate a spreadsheet or query display, and it can only be formatted as you would a spreadsheet or query, by dragging the rows or columns.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!