How do I force row height for scrollable textboxs in a subform?

I have a form with a clients info. There is a subform with messages
(date field and a textbox). There can be multiple messages per client.
The row height of the message text box in the subform is set to the
height of one line of text. I want it to display two. Changing the
size in messages table properties, form properties, and in subform
properties (from inside the client form) all have no effect when
viewing the message list from the client form.

Any help appreciated.

Re: How do I force row height for scrollable textboxs in a subform?

I'm going to guess that your form is in Datasheet View, and if so, there's
nothing you can do to to change this. In Datasheet View, basically what
Access gives you is in the beginning is all you're going to get. The usual
advice for this type of situation is to change the form to Continuous View,
where you can adjust the height of your text boxes, and format it so that it
looks similar to a Datasheet View form.

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

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

Re: How do I force row height for scrollable textboxs in a subform?

Hi Doug,

The Access textbox doesn't have a Row Height property, so it's not
clear what you're talking about. If you want to control line spacing
within the textbox, use the LineSpacing property. For double spacing
you might use

With Me.txtXXX
.LineSpacing = .FontSize * 20 * 1.2
End With

The 20 converts from points to twips, and the 1.2 gives a conventional
comfortable line spacing.

If you want to control the height of the textbox, use its Height
property, e.g.
.Height = .FontSize * 20 * 1.2 * 2 'two lines


On Fri, 16 Nov 2007 22:23:24 -0500, Doug@NoEmail.com wrote:

>I have a form with a clients info. There is a subform with messages
>(date field and a textbox). There can be multiple messages per client.
>The row height of the message text box in the subform is set to the
>height of one line of text. I want it to display two. Changing the
>size in messages table properties, form properties, and in subform
>properties (from inside the client form) all have no effect when
>viewing the message list from the client form.
>
>Any help appreciated.
>
--
John Nurick - Access MVP