module to change individual row heights

[ossse]

I have a field that is a 'memo' type. I would like to run a module that changes each row height in order to display the full text (with a fixed column width).

If you have any ideas how to do this please let me know.


Thanks in advance

 

[lameid]

I assume you want to do this on a report...

Set the can grow property of the control and the report section it is to yes / true.

As long as the control doesn't overlap others and is not shorter than other contols, it should expand fine. Although, you may just want to make it taller than necessary and set the can shrink on the control and report section too.

 

[ossse]

Sorry, it is for a table.

 

[lameid]

I'd be surprised if this can be done for a table. You could instead make a form that looks similar to a databasheet view and possibly change the height of all those cells. I think there is already code around the formu to do it to. I'll leave the search up to you.

 

[CautionMP]

...changes each row height...

When you view a table there is one row height, for all rows (remember it's Access not Excel).

As pointed out by lameid the only easy way to vary the height of a 'row' is during printing (either a form or a report) using the [tt]CanGrow[/tt] property.

Probably not much help,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[missinglinq]

End users should not even have access to Access tables! You should. as suggested, make a form that looks like a table, if that's a requirement, and then worry about changing the size of the memo field. Something like this will do:

Private Sub YourControlName_DblClick()
   If Not IsNull(Me.YourControlName) Then
      DoCmd.RunCommand acCmdZoomBox
   End If
End Sub

Good Luck!


The Missinglinq

Richmond, Virginia

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