dbTalk Databases Forums  

row height in a subform

comp.databases.ms-access comp.databases.ms-access


Discuss row height in a subform in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jean
 
Posts: n/a

Default row height in a subform - 10-08-2010 , 08:27 AM






Hi

I am able to change rows height of a continuous form containing 3
fields with a button containing the following code

[Field1].height = 480
[Field2].height = 480
[Field3].height = 480

This way the user can see more text. When finish, user click on
another button containing this code

[Field1].height = 240
[Field2].height = 240
[Field3].height = 240
[Detail].height = 240

Buttons are situated in the form header

Now I have a Main form “employee” (single) containing a continuous
subform “employeeSub”

I want to be able to change rows height of te subform with a button
situated on the main form

I have try many codes without success

Can someone help me

thanks

Reply With Quote
  #2  
Old   
Salad
 
Posts: n/a

Default Re: row height in a subform - 10-08-2010 , 03:54 PM






jean wrote:

Quote:
Hi

I am able to change rows height of a continuous form containing 3
fields with a button containing the following code

[Field1].height = 480
[Field2].height = 480
[Field3].height = 480

This way the user can see more text. When finish, user click on
another button containing this code

[Field1].height = 240
[Field2].height = 240
[Field3].height = 240
[Detail].height = 240

Buttons are situated in the form header

Now I have a Main form “employee” (single) containing a continuous
subform “employeeSub”

I want to be able to change rows height of te subform with a button
situated on the main form

I have try many codes without success

Can someone help me

thanks
I added a command button. For the click event

'display current height of a field
MsgBox Me.SubFormName!FieldName.Height
'increase height of all fields by 200 pixals
Dim ctl As Control
For Each ctl In Me.SubFormName.Form
ctl.Height = ctl.Height + 200
Next


You could create a tag (property sheet/Other) and enter Inc
Then if ctl.Tag = "Inc" then inc/dec the height.

Me.SubFormNmed!FieldName.Height = Me.SubFormName!FieldName.Height + 200

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.