Auto-adjusting row heights 1

[Luongo1]

Hi, I have one more question regarding an access project I'm working on... Is it possible to have a row automatically expand horizontally when enough data (text) is entered? Right now the text just disappears and is only visible when you click and drag on that field. I'd like it so that all the info entered is always visible. Any solutions?

Thanks...

 

[traingamer]

I'd like it so that all the info entered is always visible.

Where? In a form? In a report? In the table view?

 

[Luongo1]

Sorry, in the form - it is in datasheet mode so all the prior records are listed.

 

[dhookom]

I have never seen a solution for this. You can set controls to grow in reports/printing but I don't think it is possible in datasheet forms.

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]

I believe dhookom's right! You're pretty much stuck with whatever you set in design view. The datasheet form view is really not very practical in situations where some fields have a large amount of data. You probably should consider using another type of form.

The Missinglinq

Richmond, Virginia

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

 

[IGPCS]

i use to work in one of ms branches outside the us and we were working on the same issue with .net but i am not sure there is a solution to this yet

 

[missinglinq]

As I said before, luongo1, I think you're pretty stuck with your design; you really can't have the height being variable depending on the content, you need to size it according to the usual dimensions it'll need. The only thing I can think of to make things a little easier would be to use the ZoomBox command to expand a given field for viewing.

For a textbox named YourTextBox you would use this code:

Private Sub YourTextBox_DblClick(Cancel As Integer)
     DoCmd.RunCommand acCmdZoomBox
End Sub

Double-clicking on the field YourTextBox would then expand the field for easier viewing. Sorry, it's the best I can come up with!

The Missinglinq

Richmond, Virginia

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

 

[IGPCS]

missingling the zoombox command is a cool idea neber thaught of that thank for an idea to efficiant my great software designs