473,320 Members | 1,969 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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.

Nov 17 '07 #1
2 2139
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

Nov 17 '07 #2
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, Do**@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
Nov 19 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Kevin Robinson | last post by:
Is there any way of increasing the height of a VB form and of using a scroll bar to access the data outside of the normal window. My problem is that I need at least 40 rows on a form each row...
4
by: Paul | last post by:
Hi, I'm wondering if someone out there can help me overcome this quandary. I need to be able to calculate the height of the current page. I need to calculate the height of the page in pixels after...
2
by: JC | last post by:
Greetings all. I would like to know how to make a textboxs height = the height of the cell it's in minus 10 px or what ever number.. Using 90% for height does not work as I need it to be exactly...
8
by: Vic | last post by:
I've managed to achieve the effect I wanted in IE6 - although I had to use an experession to set the vertical height of a div (I want it to have an overflow and scroll) but I can't work out a way...
3
by: SebiF | last post by:
Hello, It might have been asked before but since I could not find a reference here's my qustion: I want a liquid layout similar to this one:...
14
by: Simon Wigzell | last post by:
I want to display HTML text inside a div and have the page open scrolled to the bottom. (My div has overflow:auto so that it appears with scroll bars) I have found this that works on a textarea:...
1
by: since | last post by:
How do I get a html table in mozilla to only have scrollbars if it is exceeds a height. "max-height" used to work but it no longer works for me. I can scrollbars added if it exceeds a height. In the...
1
by: Bob Alston | last post by:
I have a system where many subforms are used. Often the size of the subform had to be larger than could be displayed without scrolling. I set the height of the subform to the typical height...
4
by: stuckagain | last post by:
Hi, I have a page with a scrollable DIV, and within that DIV, I have a few asp.net menu controls. The idea being, the user mouses over the small icons and is presented with a list of options. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.